Use the Where Condition of the OpenForm Action.  Relational databases don't
have the concept of record #.  You "find" a record by using its primary key.

Hi Tony

Here's a little code for you to use hope it is usefull let me know how you
get on

'To Open FORM2 from FORM1 (current form) where the field is TEXT format
   DoCmd.OpenForm "FORM2", , , "[TEXTfield]='" & Forms!FORM1!
YourCurrentField & "'"
   
'To Open FORM2 from FORM1 (current form) where the field is NUMBER /
AUTONUMBER format
   DoCmd.OpenForm "FORM2", , , "[NUMBERfield]=" & Forms!FORM1!
YourCurrentField

'If you want to do a check to make sure this has gone to the right record use
' the following. I have put a procedure that if it is the wrong record
' then it will close FORM2 and display a message box but I hope you get the
' idea of how it works

' After the 'Docmd.Openform....

If Forms!FORM2!TEXTfield = Forms!FORM1!YourCurrentField Then
   Forms!FORM2.SetFocus
'or
   Forms!FORM2!ANOTHERfield.SetFocus
Else
   DoCmd.Close acForm, "FORM2"
   MsgBox "The Record Couldn't Be Found", vbCritical, "Error Occured"
End If

Rich