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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Trev" <Trev@discussions.microsoft.com> wrote in message
news:9E50C09D-9792-4C5A-B566-88DA124671D5@microsoft.com...
> 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
>