Three cascading comboboxes - how to code

[Sandy]

Hello -

I have one table (tblDeclaration) consisting of DeclarationID,
DeclarationNumText, Description and StateID. StateID is a lookup column for
the tblState. There is also another table that relates to tblDeclaration
which is the main table.

I need a cboState, cboDeclarationNumText and cboDescription. When a state
is selected in cboState, the only choices in cboDeclarationNumText are
filtered for that particular state, and also the only choices in
cboDescription are filtered by the cboDeclarationNumText.

I can't seem to even get the cboDeclarationNumText to show up, much less the
third combobox!! I think I'm getting confused with the lookup column in
state, but who's to know what I'm doing wrong . . .

The form is based on a query which joins tblMain with tblDeclaration and
tblState.

Any suggestions will be greatly appreciated!

 

[Ofer]

This link's can give you an idea on how to accomplish this task

http://www.mvps.org/access/forms/frm0028.htm

Or
http://www.databasedev.co.uk/filter_combo_boxes.html

 

[Sandy]

Thanks, Ofer!
--
Sandy

This link's can give you an idea on how to accomplish this task

http://www.mvps.org/access/forms/frm0028.htm

Or
http://www.databasedev.co.uk/filter_combo_boxes.html