combo box data changes based on previous combo box

[Damion]

Here's the example:

Combo box number #1 has two choices - month or day...

When I select "month" from combo box #1... I want Combo Box #2 to
pull from a table that has "January, February, March, etc."

However, if Combo Box #1 has "day" select....

Combo Box #2 shows "Monday, Tuesday, Wednesday, etc.".

Anyone know how to do this?


Anotehr workaround if this is not possible would be... if I could have
all choices in combo box #2, and filter which ones show up in the the
list based on what is selected in combo box #1.

Thanks for the help!

Damion

 

[KARL DEWEY]

Search on cascading comboboxes.

 

[fredg]

Here's the example:

Combo box number #1 has two choices - month or day...

When I select "month" from combo box #1... I want Combo Box #2 to
pull from a table that has "January, February, March, etc."

However, if Combo Box #1 has "day" select....

Combo Box #2 shows "Monday, Tuesday, Wednesday, etc.".

Anyone know how to do this?

Anotehr workaround if this is not possible would be... if I could have
all choices in combo box #2, and filter which ones show up in the the
list based on what is selected in combo box #1.

Thanks for the help!

Damion

If those are the only choices, the name of a month or the name of a
day, then set the Combo2 RowSourceType property to Value List
Leave the Combo2 RowSource blank.

Code the Combo1 AfterUpdate event:

If Me!Combo1 = "Month" Then
Me!Combo2.RowSource = "'January';'February';'March'; 'etc...' "
Else
Me!Combo2.RowSource = "'Monday';'Tuesday';'Wednesday'; 'etc....' "
End If

 

[yanz]

Hi, I've got the same problem before..
You can try download this example,
Basing One Combo Box on Another Sample Database at:
http://www.microsoft.com/downloads/...a1-3c4e-4371-81e4-f9347b7a1dd7&displaylang=en