Heirarchical Combo Boxes?

[Guest]

Hi I need to create heirarchical combo boxes.

In case you're not understanding what I mean, imaging we have a table called
orders which lists all orders and contains user IDS against all orders.

I want a form that will display all the user IDS (which is easily done with
a combo box) but then I want a second combo box that will only display order
numbers against the user selected in the first combo box.

Can this be done and if so how? Also, can you have 3/4/5/6 heirarchical
combo boxes?

Thanks in advance.

 

[Mark M]

Do a search (Google or Access' Help or this forum) for terms like "cascading
combo box". You'll find lots of good explanations and examples.

Basically, when you select a row in one combo box, the After Update event
create a new rowsource for the next combo box; when you select a row in that
one, it will in turn create a new rowsource for the next combo box, etc.,
etc.

 

[Allen Browne]

Set the RowSource of each combo in the AfterUpdate event of the previous
one.

Details in:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm

 

[Guest]

Hi,

I too have this problem, and another question arising from it..

Suppose we setup two tables, tblUserID and tblOrder and link them with a
one-to-many relationship, it will work the way Richard Horne wants it to, as
long as we enter data directly into the tables.

Why can't this be 'carried over' to a Form? Why can't the two Combo boxes
for UserID and Order made follow the rule set by the table link, without
resorting to code?

Thanks

David J