Seach table from within a form

[95DSM]

I would like to create a form that has a table or list embeded in it. At the top are certain attributes that I can search by and when I click the search button the list/table sorts the names entered. Attached is a picture to help you fully understand my needs.



I have been working with this in design view and searching the properties box and I can find a way to do it.

[pbaldy]

One way is demonstrated in the sample db in this FAQ:

http://www.baldyweb.com/BuildSQL.htm

[95DSM]

Is the only way to do this with some VB programming? I haven't been into programming for about 2 years now and I'm really rusty. Thanks for your help so far.

[pbaldy]

Well, you could use a query with criteria like:

Like "*" & Forms!FormName.ControlName & "*"

or this technique:

http://www.mvps.org/access/queries/qry0001.htm

[95DSM]

I looked through the information you posted but nothing really stood out on what I needed to do. Some sort of terminology or process would be very useful. I could be completely blind and just missed it though. Here's a pic of my current form and what I need it to do.

I would like to put a keyword like Dell in the textbox. Then I would select a category that would apply best (They are checkboxes currently, but will be changed to radi buttons). In this case it would be Manufacturer. Now when I press search I would like to see the table below fill up with enteries that only list the manufacuter named Dell. No HP or Compaq. I dont want to be able to edit, delete, or add additional items. This will be for viewing purposes only. Afterwards I would use the reset button and clear the table back to original settings.

Now I'm not asking for someone to write me code. I just would like to know different ways to do this. Maybe using a query, an embeded filter, or etc. What would be some terms I could use to find some examples?

[pbaldy]

The db in the first link would be how I'd go, because of the checkbox. You're dynamically changing the field to be filtered, so I'd build SQL in VBA.