D David Feb 12, 2004 #1 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?
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 Feb 12, 2004 #2 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
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