Multiple combo boxes that filters records in a form

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Sam Kuo (sam_cy_kuo_at_yahoo.com.(donotspam))
Date: 07/05/04 

Date: Sun, 4 Jul 2004 22:18:01 -0700

Could anyone please help me with the following?

How to:
1) create 2 combo boxes, each dispalying unique values from a field of table/query containng multiple occurences of each values?
2) then sychronize these 2 combo boxes and filter records in a form based on my selection in the combo boxes?

Example:
tblGrocery (containing fields of Category, Type, ProductName)
cboCategory
cboType (depend on the selection of cboCategory)
frmGrocery (based on tblGrocery)

After selecting Fruit in cboCategory, then Apple in cboType, records under Apple (red apple, green apple,...) are filtered in a form.

Your kind help is much appreciated from a very frustrated man!

Relevant Pages

  • Re: Multiple combo boxes that filters records in a form
    ... Limit content of combo/list boxes ... > cboType (depend on the selection of cboCategory) ... Apple are filtered in a form. ...
    (microsoft.public.access.forms)
  • =?Utf-8?Q?Re:_intermittent=E2=80=94delete/backspac?= =?Utf-8?Q?e_key_not_working?=
    ... I have field shading set to always and there is no field in this case. ... I changed it to W97 and all boxes within are now unchecked. ... Backspace: This is governed by the "Typing replaces selection" check box Jay ...
    (microsoft.public.word.docmanagement)
  • Re: Using combo box selection to supply criteria for query
    ... Sorry, I am still learning SQL and VBA, I don't think that I made the ... The form contains 5 combo boxes; SBT Account, Region, ADM, Month, Year ... If I only make a selection in the Region combo box ... Post the query SQL. ...
    (microsoft.public.access.forms)
  • Re: Free Apple stuff
    ... haul--there are about forty copier-paper boxes of Apple II ... Several copier-paper boxes are full of Apple II ... WAP is definitely open before driving there if you wish. ... building working computers for school kids who can't afford them. ...
    (comp.sys.apple2)
  • Re: Free Apple stuff to a good home...
    ... haul--there are about forty copier-paper boxes of Apple II ... Several copier-paper boxes are full of Apple II ... WAP is definitely open before driving there if you wish. ... building working computers for school kids who can't afford them. ...
    (comp.sys.apple2.marketplace)