COMBO Box listing dependent upon a field entry...

[R32chaos]

Hello members...

I would like a combo box list source to change based on a previous drop down.

I mean, when I choose a type of item being purchased, next, I would like a combo box to populate its choice list from the specific table or query which contains inventory listing for the chosen item type.

I know inventory should be kept in one table but in this case it is from two different tables and the fields in each table are different.

Any help will be appreciated.

Regards, Martin

 

[pbaldy]

You should be able to adapt the second method here to your needs:

http://www.baldyweb.com/CascadingCombo.htm

 

[John Big Booty]

What you are talking about is a cascading combo box.

There are some examples here or do a search in this forum as the topic comes up on a regular basis.

 

[R32chaos]

You should be able to adapt the second method here to your needs:

http://www.baldyweb.com/CascadingCombo.htm

Thank you!
Only problem is, the combobox could be showing more than one fields when clicked upon. I think the cascading concept appears to only work with a combo box which lists only one field.

Any additional help will be appreciated.

 

[R32chaos]

What you are talking about is a cascading combo box.

There are some examples here or do a search in this forum as the topic comes up on a regular basis.

THANK YOU!!
I appreciate the great source of examples you have referred me to. I think this will not only help me with the cascade-combobox concern but will enlighten me in many more ways.

Again, thank you!
Regards, Martin