Combo Boxes, Filtering, and Requerying

cgdrake

Registered User.
Local time
Yesterday, 21:26
Joined
Jul 22, 2007
Messages
38
Hello--I'd like to request your help. I've created a form where I use combo boxes to narrow down user choices. The combo boxes have an SQL statement for a RowSource, and this works well. However, I can't get the the record pointer off the first record and filter them down to the criteria chosen in the combo box. I tried an OnCurrent Event in the form itself which added the filter, along with a macro in the AfterUpdate event of the combo box (the macro said to set the FilterOn to yes and to requery), but this did not work. Does anyone have any insight on this? Thanks.
 
Search on "Cascading combos" heres a little example that might get you started...
 

Attachments

Users who are viewing this thread

Back
Top Bottom