Opening a subform in new window by button 1

[jmob]

I am opening up a subform in a new window by the use of a button. Form A is the parent, Form B is the child. A 1-many relationship. When pressing the button on Form A, Form B pops up with the appropriate records linked by idKey. However, when I create a new record in form B, (B)idKey is not set to that of its parent value (A)idKey. Is there a way to update idKey in form B to equal that of idKey in form A? I think I need some VBA for this.
Thank you!

 

[PHV]

As you prefer another mainform to pop up instead of a real subform you may consider playing with OpenArgs and DefaultValue.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886