Populating a subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I havbe a table where I want to pop up a su=bform based on a code that is
picked from a combobox. My question is that there can be more than 1 record
added to this subform, which will ultimately be added to a report. How do I
set it up so that when I finish adding a record and go to a new one that the
foreign ID is automatically populated in the new record? I think I know how
to get the subform to pop-up but help in that area would be appreciated also.
Is there a book taht deals with subforms that anyone would recomen.

TIA
 
If you've set up the relationship between the two tables (Tools,
Relationships), using the Form Wizard to create the Main + Subform will
ensure the foreign key is updated automatically. If you're setting up the
subform manually, just make sure the Link Child Fields and Link Master Fields
mirror the link between Main table/form and Sub table/form (these are found
in the properties for the subform).
 
Back
Top