Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Finding A Record In An Access Form

Status
Not open for further replies.

SandraF

Programmer
Jan 25, 2001
28
US
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top