How can I synchronize two forms to the current view?

D

David

I would like to open a second form and have it go to the
current record of the first form without using a sub-form.

How can this be done?
 
C

chris

Use this code to open your new form...

DoCmd.OpenForm "<YourFormName>", , , , , , "Id of current
record as a string"


Use this code in the form_open event of the form you are
opening

Me.Filter = "<BoundPrimaryKey> = " & Me.Openargs
Me.Filteron = true
 

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

Request Form - Alert Team Member 0
How do I clear a form? 0
Split form 0
Synchronization problems while moving folders to new email 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Countdown macro - display settings 2
Copy previous record into form field 0
Access 2010 DB not fuctional with multiple users 2

Top