Hello, thank you in advance for suggestions.
I have a form with a subform. I want to have a field on my form (shipmentnumber) also add the shipment number to the table my subform is linked to so I can link the two tables together using this number.
I am a MS Access novice, so I need something fairly simple.
Thanks again.
Typically one would use a Form based on a table with a Primary Key, with a
Subform based on a table containing a "Foreign Key" field. You would use the
Primary Key as the Master Link Field of the Subform control, and the
corresponding Foreign Key as the Child Link Field.
With this setup, when you enter data into the subform, it will automatically
"inherit" the value from the Master Link Field. No programming or other effort
is required; you don't even need to display the values of the fields, unless
you have some other reason to do so.
One concern - it looks like you're concentrating on the Forms. That's good,
but just be aware that the Tables are the REAL data; the Form is just a tool,
a window to manage the data stored in tables. You need to be sure that your
tables and their relationships are correct.
--
John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://answers.microsoft.com/en-us/office/forum/access?tab=question&status=all
http://social.msdn.microsoft.com/Forums/office/en-US/home?forum=accessdev
and see also
http://www.utteraccess.com