opening from 1 access form 2 another at same data info

  • Thread starter Thread starter Trev
  • Start date Start date
T

Trev

Help please , im still learning 2007 access , i have created two forms
relating back to one table and i want to switch between them but when i do
they go back to the first record . How can i switch between keeping the same
data record . many thanks
Trev
 
Use some code in an event, probably the click event of a command button:

Sub MyButton Click()
DoCmd.OpenForm "frmNumberTwoName", , , "IDkey =" & Me.txtIDcontrol
End Sub

where frmNumberTwoName is the name of your second form, IDkey is the name of
the Primary Key field, and txtIDcontrol is the name of the textbox holding
the IDkey value, in the first form.
 
Back
Top