Transferring ID numbers to multiple forms for one subject

[clackl]

I have a database where I keep extensive records for individuals. These involves one main demographics form with a unique ID number. The rest of the information is kept in a number of individual forms accessed by control buttons on the main form. However each time I access the forms via this button I need to reenter the ID number.

Is there a way of making this happen automatically.

(The forms are linked on ID number as the primary key in each form).

 

[cranebill]

What do you mean you need to reenter the number... does the form come up blank? Or is there a pop up asking for criteria?

Bill

 

[clackl]

The form comes up blank.

 

[cranebill]

I think you should be able to modify the Record Source SQL of your second form to use criteria by adding a where clause. For example:

Select * From [YourTable] Where [YourField] = Forms![MainForm]![IDNumber]

This will work provided the main form stays open. If you are planning to Close the main form you will need to open second form prior to closing main form. Hope this made sense.

Bill