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
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