Hi All,
I have a little issue. I am trying to open a form, showing a specific record based on the selection in a list box. I am using the following code and getting "mismatch" error:
DoCmd.OpenForm "frmClients", , , _
"[tblClient.ClientID]=" & "'" & Me.lstSearch.Column(0) & "'"
The form I am opening is "frmClients", which is opened by double clicking on a list box, named "lstSearch". ClientID is a Autonumber. Anyone have any ideas?
Thanks,
I have a little issue. I am trying to open a form, showing a specific record based on the selection in a list box. I am using the following code and getting "mismatch" error:
DoCmd.OpenForm "frmClients", , , _
"[tblClient.ClientID]=" & "'" & Me.lstSearch.Column(0) & "'"
The form I am opening is "frmClients", which is opened by double clicking on a list box, named "lstSearch". ClientID is a Autonumber. Anyone have any ideas?
Thanks,