Macro to open another from and link to the current record

M

Mal

How can I open a data entry form from the current record form, and maintain
the link between the 2 forms. The macro I have written will open the form I
want for data entry but it keeps going to the first record. It is not making
a connection with the current record.

Thank you
Mal
 
S

Steve Schapel

Mal,

Assuming you are using an OpenForm action in your macro, I guess you
will need to use the Where Condition argument, based on the primary key
field of the second form. Something like...
[ID]=[Forms]![NameOf1stForm]![ID]
 

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

Adding data to MS Access from csv file 0
How do I clear a form? 0
Copy previous record into form field 0
Embed the same Excel multiple times 0
Improving Macro That Keeps First Letter 0
Building Blocks and Macros 5
Need Help with Macro Security 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1

Top