MS Access - query a form question
Posted on 2011-02-15
I have a form that I wanted a quick way to navigate to a specific record via a 'ticket number'
I came up with this to avoid having to write a query and involve a new form but is there a way to use a query called by a button to retrieve the matching record(s) and make the form navigate to the record(s)? I know that would be much quicker than this method.
Thanks for the help
DoCmd.GoToRecord acDataForm, "TicketForm", acGoTo, 1
Do Until TicketNumberEntry = TicketNumberBox
DoCmd.GoToRecord , , acNext