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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate subform field on Afterupdate of main form field 6
Access Main form/Subform Navigation 0
Scroll bar in a subform 2
Populate subform new records with dates 1
Populate query in a subform based on selection from combobox in main form 0
Automatically resize subform height based on number of returned re 1
Adding Record to Subform 2
Move to next record on subform 2

Back
Top