Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Option button

Status
Not open for further replies.

chasmith17

Technical User
Joined
May 25, 2006
Messages
47
Location
US
Hello,
I have a parts database that has Part desc., Part number, and part location feilds. Also I have a few categories where the parts belong to that are designated by Option buttons. I would like to know how to setup a form to search by parts that belong to a category? For instance when I select the option button for a certain category it will show me all of the parts associated with the category(part desc,part number and location). Hope this is clear. Thanks for the help.
 

You might consider populating a list box or control box based on the results of a query that uses the option button as criteria.

Randy
 
Randy,
I have not worked with access for a few months so it seems I have forgotten alot of things. I am having trouble remembering how to write the criteria for the query. In my query do I need to include all categories or do I create a query for each category?
 

I would write a query that selects all the fields you desire based on the category selected. Use the query as the record source of your list or combo box. You will probably have to include a me.requery on the list/combo box whenever the option selection changes.


Randy
 
Randy,
I figured it out. It's slowly coming back to me. Thanks for the help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top