filtering records

So i have a form that shows all the records of products. Each of these
products belong to a category. What i want to do is have a drop down menu
that lists all the possible categories. When a user selects a category i only
want the form to show the products that belong to that category. How would i
go about doing that?

One way to achieve this would be to have the form based on a query that uses
the contents of the combobox as a selection criterion.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"nzquikster" wrote in message
...
So i have a form that shows all the records of products. Each of these
products belong to a category. What i want to do is have a drop down menu
that lists all the possible categories. When a user selects a category i
only
want the form to show the products that belong to that category. How would
i
go about doing that?

In your form header use an unbound combo with source that lists all the
possible categories. Use the combo as query criteria to feed the form. Use
an event on the combo, AfterUpdate, to refresh the form.

--
Build a little, test a little.


"nzquikster" wrote:

So i have a form that shows all the records of products. Each of these
products belong to a category. What i want to do is have a drop down menu
that lists all the possible categories. When a user selects a category i only
want the form to show the products that belong to that category. How would i
go about doing that?

thx guys, i got to work =)

"KARL DEWEY" wrote:

In your form header use an unbound combo with source that lists all the
possible categories. Use the combo as query criteria to feed the form. Use
an event on the combo, AfterUpdate, to refresh the form.

--
Build a little, test a little.


"nzquikster" wrote:

So i have a form that shows all the records of products. Each of these
products belong to a category. What i want to do is have a drop down menu
that lists all the possible categories. When a user selects a category i only
want the form to show the products that belong to that category. How would i
go about doing that?

I have a simmilar problem, but i can't seem to get my Query to respont to
the combo box. It just lets me choose an entry and does nothing!

The query works if i use criteria such as "Like "*" [Enter Merit Badge name]
"*"
I get the correct data, but i can't seem to get that to work with the form???

HELP

-
Dick Patton
Boy Scout Troop 403


"KARL DEWEY" wrote:

In your form header use an unbound combo with source that lists all the
possible categories. Use the combo as query criteria to feed the form. Use
an event on the combo, AfterUpdate, to refresh the form.

--
Build a little, test a little.


"nzquikster" wrote:

So i have a form that shows all the records of products. Each of these
products belong to a category. What i want to do is have a drop down menu
that lists all the possible categories. When a user selects a category i only
want the form to show the products that belong to that category. How would i
go about doing that?