Can i make Search through Form?

Hello,

I've started a new database of suppliers, I have a table and a form. I know I can go into query and do a search on the products column of the table but is it possible to create a search box on the form which, when you put a product into the box, will go through all the suppliers who sell that particular product, showing them at the click of a button (or mouse), in turn?

I have plenty of experience at basic level with Access but am I expecting too much of '97 to be able to do this, or is it possible?

You can make search by this:
If all the data is available meaning the search field is been shown or in the query all you have to do is use the filter function.
give u exact records that contains the value in textbox.

1. me.filter = "[product]=" & me.textbox
me.filterOn = true
give u anything that start with what in the textbox:
2. me.filter = "[product] like " & me.textbox & "*'"
me.filterOn = true

second approach is more appropriate for search function

Product Search through Form?

Yes you can do that, one way is this:

Please Login or Register  to view this content.