Open form to specific record without filtering the open form?

[d9pierce1]

Is it possible to open a form with a cmdbtn to a specific record without filtering the form that you open?

Private Sub CmdAccountDetails_Click()
  DoCmd.OpenForm "frmAccountDetail", , , "[AccountID]=" & Me.AccountID
  DoCmd.Close acForm, "frmAccount"
End Sub

Thanks
Dave

[June7]

Would have go to record. One method uses bookmarks. Review Form.Bookmark property (Access) | Microsoft Docs

Use OpenArgs to pass the AccountID to form. Then in its Open event:

If Not IsNull(Me.OpenArgs) Then
'code to go to record
End If

Instead, could use form/subform arrangement.

[d9pierce1]

thank you June7,
I will give that a shot
Dave

[Gicu]

An alternative I used to use a few years ago, should still work:

Private Sub CustomerID_DblClick(Cancel As Integer)


Dim CurrentCustomer as Long


Me.Dirty=False
DoCmd.Echo False
CurrentCustomer = Me.CustomerID 
DoCmd.OpenForm "frmCustomer"      
Screen.ActiveForm![CustID].SetFocus  'control holding the ID you want to load
DoCmd.FindRecord CurrentCustomer
DoCmd.Echo True


End Sub

Cheers,