opening all to a specific record 1

[manny1234]

I have a form set up where I view one record at a time. I have arrows were I can scroll through records, or I can search in any of the fields on the form for a specific record.

I have a box that lists all of the records I have viewed and I can click the specific listing to open that record in the previous form mentioned. when I do that though it only opens that one record for viewing so I cannot use my arrows or search. Here is the code I use

Private Sub List0_DblClick(Cancel As Integer)
DoCmd.OpenForm "MD_ActView", , , "[ID] = " & Me![List0] & ""
End Sub

Is there a way I can open a form to a specific record but also have all the other forms open?

 

[PHV]

Provided MD_ActView is already open:
Private Sub List0_DblClick(Cancel As Integer)
Forms!MD_ActView.Recordset.FindFirst "ID=" & Me!List0
End Sub

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[manny1234]

it opens MD_ActView but it opens it to the first record, not the record specified...

 

[manny1234]

got it working

Dim WTF as String
WTF = Me!SharedW
DoCmd.OpenForm "MD_ActView" 
Forms!MD_ActView.Recordset.FindFirst "[Merchant Id Number]= '" & WTF & "'"

Thanks for the help!