Hi Debbie
Yes - no problem
Question is: Do you want to see ONLY the one record in the second form, or
do you want to be able to scroll through all records but start on the given
one?
If it's the first option, then add a WhereCondition to your OpenForm
statement (this is the 4th argument):
DoCmd.OpenForm "Form2", , , "[KeyField]=" & Me.[KeyField]
If you want to scroll all records, pass the key field value via OpenArgs
(the 7th argument) and navigate to the desired record in the second form's
Load event:
DoCmd.OpenForm "Form2", , , , , , Me.[KeyField]
Then, in Form2:
Private Sub Form_Load()
If Not IsNull(Me.OpenArgs) Then
With Me.RecordsetClone
.FindFirst "[KeyField]=" & Me.OpenArgs
If Not .NoMatch Then
Me.Bookmark = .Bookmark
End If
End With
End If
End Sub
Note that if your key field is a text field then you must enclose the value
in quotes:
"[KeyField]='" & Me.[KeyField] & "'"
and
"[KeyField]='" & Me.OpenArgs & "'"