Hi,
I am trying to open a form at a specific record using a combo box. the combo box is Combo23 the form I am opening is called Frm_Visit_Details the field on the form I want to use to determine which record to open is called Visit_ID I have created a button with a click event to open the form and the code I am using is:
Private Sub Command5_Click()
DoCmd.OpenForm "Frm_Visit_Details", acNormal, , "[Visit_ID] = " & Me.Combo23 & """"""
End Sub
where am I missing an operator, I have tried various combinations of " and ' and can't seem to get it to work properly.
Thanks
J