Automatically fill a field from one form in another field on a seperate form

[Ivan Grozney]

On your second form (make sure the first form is still
open, it can be minimized I think) in the text box that is
the linked value (memberID???) put in something like this
for the default value:

=[Forms]![<yourMAINform>]![linkedID]

ex: =[Forms]![fm_Member].[memberID]


That way when you fire off the MemberSpouse form, it will
default your MEMBERID from the Member form.

hth

Ivan

-----Original Message-----
I have two forms, one is a members form, the other a

member spouse form. When I have completed filling in the
the member information I click a command button to opne
the spouses form. When this happens, I want a field the
member spouse form to automatically display the member ID
from the member form. How can I do this, as I have the
tables linked through the member ID field?

 

[Evan McCutchen]

Ivan,

Is there a way to pass that information without changing the Field Default
values?

Thanks,
Evan McCutchen
evan AT radiologyonesource DOT com

On your second form (make sure the first form is still
open, it can be minimized I think) in the text box that is
the linked value (memberID???) put in something like this
for the default value:

=[Forms]![<yourMAINform>]![linkedID]

ex: =[Forms]![fm_Member].[memberID]


That way when you fire off the MemberSpouse form, it will
default your MEMBERID from the Member form.

hth

Ivan

-----Original Message-----
I have two forms, one is a members form, the other a

member spouse form. When I have completed filling in the
the member information I click a command button to opne
the spouses form. When this happens, I want a field the
member spouse form to automatically display the member ID
from the member form. How can I do this, as I have the
tables linked through the member ID field?

Thanks,
Craigger

.