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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

GoToRecord Syntax when searching on a specific field

Status
Not open for further replies.

mas5

Programmer
Dec 15, 2002
98
US
I have a form that allows a user to select a customer record they want to see the details for. They click on the record and then I have a pop up form that positions the customer table at the customer record they have requested. I'm having trouble getting to the specific record. I want the user to be able to go to other customer records as well so I don't want to use a filter because they'll be limited to just that one record.

I've tried variations of:

DoCmd.GotoRecord

but I can't figure out how to note that the search should be on the customerid field. Can anyone help with this syntax?

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top