UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Select Form From Another Form    
 
   
jdepinet
post Jan 9 2011, 10:07 AM
Post #1

UtterAccess Veteran
Posts: 328
From: Indianapolis Indiana
I have a loaded form "frmAlarm" that is unfiltered (It is a new record that I save before the next ->) On frmAlarm the user selects a command button and it pops up "frmAccount" that is not related to frmAlarm. When I close frmAccount frmAlarm goes to the first record in the table. This is what I want: When the user closes frmAccount it displays the same record in frmAlarm that was displayed before losing focus to frmAccount.

FYI When the record in frmAlarm is not new (Filtered) it works fine. Thanks John
Go to the top of the page
 
+
jhcarrell
post Jan 9 2011, 10:49 AM
Post #2

UtterAccess Veteran
Posts: 455
From: Birmingham, Alabama
Can you post an example db of problem you're encountering. I'm pretty sure I can sort this out for you, but i'll need see your setup for opening and closing the form.

Thanks.
Go to the top of the page
 
+
jdepinet
post Jan 9 2011, 10:56 AM
Post #3

UtterAccess Veteran
Posts: 328
From: Indianapolis Indiana
I think I jusy need code to select a record on the form when I close another form. Really don't want to upload because I have data in the tables and I'm hoping to get a answer or find the answer in a short amount of time. Any other help out there? Thanks John
Go to the top of the page
 
+
jdepinet
post Jan 9 2011, 11:16 AM
Post #4

UtterAccess Veteran
Posts: 328
From: Indianapolis Indiana
Ok, this is causing the change of record: OnClose Forms!frmalarm.Requery

When I take it out it stays on the same record. Do I need to add "me" in there to stay on the same record?
Go to the top of the page
 
+
jhcarrell
post Jan 9 2011, 11:18 AM
Post #5

UtterAccess Veteran
Posts: 455
From: Birmingham, Alabama
How are you opening the frmAccount? macro or VBA? How are you closing the frmAccount? macro or VBA? In either case, please provide the full code on the buttons for the method you are using.

Thanks.

Edit: n/m answered while I was typing.

This post has been edited by jhcarrell: Jan 9 2011, 11:19 AM
Go to the top of the page
 
+
jhcarrell
post Jan 9 2011, 11:21 AM
Post #6

UtterAccess Veteran
Posts: 455
From: Birmingham, Alabama
QUOTE (jdepinet @ Jan 9 2011, 10:16 AM) *
Ok, this is causing the change of record: OnClose Forms!frmalarm.Requery

When I take it out it stays on the same record. Do I need to add "me" in there to stay on the same record?


What is the purpose of the requery as you stated the forms are not related?

If the information from frmAccount's table has no impact on frmAlarm's table, I'm not seeing why you really need to requery.

Thanks.
Go to the top of the page
 
+
jdepinet
post Jan 9 2011, 11:30 AM
Post #7

UtterAccess Veteran
Posts: 328
From: Indianapolis Indiana
When frmAccount opens it show all of the account activity for the current frmAlarm. frmaccount uses a listbox (query) based off of the pk in frmAlarm. From frmAccount the user can add a new activity that could change the balance field on frmalarm. I'm just trying to show the updated account balance field on frmAlarm.
Go to the top of the page
 
+
jhcarrell
post Jan 9 2011, 11:44 AM
Post #8

UtterAccess Veteran
Posts: 455
From: Birmingham, Alabama
See this link

Hope that helps.

This post has been edited by jhcarrell: Jan 9 2011, 11:44 AM
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th May 2013 - 10:31 AM