Subform - Link info to Main Form

[RogueJD]

I'm trying to use a form for a Warehouse.

I have an ID number for each "Customer" on the main form, and a property list on a Subform.

How do I link the two forms so that every time I bring up an ID number on the main form, It loads the property list for that ID on the subform?

I apologize if I'm asking some basic questions, but this is the first time I've created a database from scratch.

The problem I have now is when I update property on the subform, it says that the primary key can not be a nul value. I set up a relationship linking the id on the subform to the id on the main form.

Ideally, when I load an ID number in the master form, it will generate all of the property for that ID on the subform. I don't wan to have to enter the ID in two places, and I don't want the ID to be visible on the property subform.

I'm assuming there's an easy fix that I'm overlooking.
Thanks, all.

 

[pbaldy]

Typically forms and subforms are kept in sync by the master/child link properties of the subform control (not the subform, the subform control on the main form). If you used the subform wizard, it should have asked you; in any case, check them and see if they're right.