One details form, called from many.

[Bradley C. Hammerstrom]

Access2000

How can I set the control source for the fields on one form, so that when I
open it from two or three other forms, the called form's fields display the
same info as in the calling form no matter which calling form opened it?

Example:
Form1, and Form2 each have Name and Address fields. They also have a
cmdOpenDetails that opens the Details form. The Details form needs to be
able to display whatever Name and Address is shown on either Form1 or Form2,
whichever one the user clicked cmdOpenDetials from.

Brad H.

 

[JohnFol]

Tons of ways to do it.
For example on the On_Click I presume you do a Docmd.OpenForm.
The last argument of this is OpenArgs. Put the calling form name in it. Then
on the Open event of the details form, do the following
me.Address1 = forms(me.openargs).Address1
me.Address2 = forms(me.openargs).Address2

and so on .. . .