I need to create a form that will search existing records from a query record source, and then be able to update the data tables to new values when necessary.
The first problem is with the search. When I search for a record with Item# 'xxxy' the form displays the "first" record with said Item#. There are multiple records with said Item#, so how can I make the form scroll between the records that contain Item# 'xxxy', so the user can pick which one to update?
The first problem is with the search. When I search for a record with Item# 'xxxy' the form displays the "first" record with said Item#. There are multiple records with said Item#, so how can I make the form scroll between the records that contain Item# 'xxxy', so the user can pick which one to update?