Form linked to another form

[linanderson]

I have a form based on a 'Customer' table. There are controls on the form which link to other forms such as products, contact history etc. When set up the controls link the forms by the CustomerID so I only see that customers information. So far so good. My problem is that if someone wishes to add a new product for that customer (or contact history etc), when they click on the control which opens that form, they must enter the Customer ID again. The ID does not follow onto the last record of the form which is used for any data entry. Everything is Ok as long as they do this but I would like theis to be more helpful to the users. Is there any way of getting around this? Thanks in advance for any help.

 

[Alexandre]

You should use subforms instead, and set the parent/child field to your ID.