Macro to open another from and link to the current record

G

Guest

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

Access Automatically Send a notification email once a record is added 0
Pop-up form that creates record that links 1:1 to main form 0
condition for current record only 1
Access Command to run access, open to specific form and specific record 1
Macro to automatically print current record on update to a report 5
How to open a form from another form GOING TO THE CURRENT RECORD? 1
searchforrecord macro pulling wrong record 5
Access Click in Table to Open Form 0

Top