I have two combo boxes on a form that the lets the user pick a value from each one.
There is a command button that says find and when the user clicks on that , it takes the two variables in the combo boxes and finds that record and displays it.
The following code keeps getting a syntax message.Me.RecordsetClone.FindFirst ("[GroupName] = '" & GroupPick & "'" And ("[GroupTitle] = '" & TitlePick & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
I just want to go to that record.
Thanks!
There is a command button that says find and when the user clicks on that , it takes the two variables in the combo boxes and finds that record and displays it.
The following code keeps getting a syntax message.Me.RecordsetClone.FindFirst ("[GroupName] = '" & GroupPick & "'" And ("[GroupTitle] = '" & TitlePick & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
I just want to go to that record.
Thanks!