How Do I Open a new form at a specific record when....

[bluemat]

How Do I Open a new form at a specific record when.... the record is not created.

Hmm

I have a main form - linked to a main table. From here I want users t be able to add info in other forms, but I want all forms to share the same ID-

How can I open the form at a new record which already has the shared ID of the main form in place -the same as?

 

[jfischer]

You first need to save the record being used by the main form. The other forms won't see the record until you do, because the new record hasn't yet been written to the table. It only exists in a storage buffer for the main form.

For example, you could use the following statement in the main form to save the new record before opening another form:

DoCmd.RunCommand acCmdSaveRecord