Multiple combo boxes that filters records in a form
From: Sam Kuo (sam_cy_kuo_at_yahoo.com.(donotspam))
Date: 07/05/04
- Next message: Allen Browne: "Re: Multiple combo boxes that filters records in a form"
- Previous message: Allen Browne: "Re: Custom navigation controls"
- Next in thread: Allen Browne: "Re: Multiple combo boxes that filters records in a form"
- Reply: Allen Browne: "Re: Multiple combo boxes that filters records in a form"
- Messages sorted by: [ date ] [ thread ]
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!
- Next message: Allen Browne: "Re: Multiple combo boxes that filters records in a form"
- Previous message: Allen Browne: "Re: Custom navigation controls"
- Next in thread: Allen Browne: "Re: Multiple combo boxes that filters records in a form"
- Reply: Allen Browne: "Re: Multiple combo boxes that filters records in a form"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|