rinkydink
asked on
MS Access - query a form question
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
Loop
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
Loop
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks guys!
me.filter="[TicketNumberEn
me.filteron=true