Load/Activate Form depending on where Form called from

[lastout]

I have two forms that both can be loaded from a main switchboard. There is a button on Form B that can also load Form A (but user cannot go from Form A to Form B). When loaded from the switchboard, the OnLoad event takes the user to a new record and maximizes the window. When the user is in Form B and wants to go to form A, leaving form B open for the time, I would like the record that shows in Form A to be the same as the one they were dealing with in Form B. So I have to override the OnLoad event that goes to a new record when Form A is loaded (from the switchboard). If Form A is already open and the the user clicks the button on Form B that calls Form A, then the user should still be taken to the same (linked) record that was selected in Form B.

Can anyone put me on the right track to achieve this? I know it's a fairly common feature in databases but being new to this, I'm not sure what code and functions to use. Any advice is greatly appreciated! Thanks in advance. lastout (the game's not over till it's over)

 

[sko]

Ok which came first, the chicken or the egg?
1.User enters data in FormB
2.User wants to see related data in FormA?
3.What's the relationship between FormB, FormA? One to Many? That's not clear to me because you are also saying you open FormA by itself to enter new records.

How will FormB know if FormA is already open?
See [thread702-60655] for IsOpen, IsLoaded example

You might also search Access help for openarg property.