Open to specific record, not filter to record

[templeowls]

So I've got tabular form of customers, and each customer has an 'open' field. Clicking this field opens a second form that shows that specific customer's info. I want this 'open' field to just open to the specific customer, NOT filter down solely to that customer. I want to be able to freely move from customer to customer within that second form if needed. Is that possible?



I'm using the following 'on click' code for the 'open' field, but it keeps filtering the second form solely to that customer. Any suggestions?

Private Sub txtOpen_Click()
On Error GoTo txtOpen_Click_Err


    DoCmd.OpenForm "frmCustomerDetails", acNormal, "", "[ID]=" & Me.ID, , acDialog


txtOpen_Click_Exit:
    Exit Sub


txtOpen_Click_Err:


    MsgBox "Error #" & Err.Number & " - " & Err.Description, , "Error"
    
    Resume txtOpen_Click_Exit


End Sub

[Bob Fitz]

Try this in the click event:

DoCmd.OpenForm "frmCustomerDetails", , , , , , Me.ID

And this in the Open event of frmCustomerDetails:

If Not IsNull(Me.OpenArgs) Then
    Me.Recordset.FindFirst "ID = " & Me.OpenArgs
End If

[templeowls]

That worked! Thanks Bob!

[Bob Fitz]

That worked! Thanks Bob!

Glad you have a solution.

Perhaps you could mark this thread as solved.