Search form for multiple record possibilities

[maw230]

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?

 

[jdraw]

Could you set up the search to
a)"find" more than the Item# 'xxxy', perhaps another field to help limit the number of records found

b) output the result set in a list box to show all, or at least several, records in result set?

My thinking is-- what if you get 50 or 100 records returned - do you really want to go through these 1 at a time?
Perhaps searching on more fields, using Like * values, will reduce the result set.

Just my $.02

 

[maw230]

Could you set up the search to
a)"find" more than the Item# 'xxxy', perhaps another field to help limit the number of records found

b) output the result set in a list box to show all, or at least several, records in result set?

I just created a list box based on two fields which created a unique enough way to find records. I wouldn't have known to try a list box had you not mentioned it, so thanks.

 

[jdraw]

Good stuff, glad you have a solution.

 

[John Big Booty]

This sample may be of interest to you.