If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
filtering records
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? |
#3
|
|||
|
|||
filtering records
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? |
#4
|
|||
|
|||
filtering records
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? |
#5
|
|||
|
|||
filtering records
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? |
Thread Tools | |
Display Modes | |
|
|