Values in bound combo boxes

[Guest]

I have 2 bound combo boxes in a form. I am trying to automatically put a set value in the 2nd combo box according to what was entered into the first combo box...please help!

 

[JulieD]

Hi Duane

not sure what you mean by putting a set value in the 2nd combo box ...
do you mean filtering the available list in the second combo box by what is
in the first (if so then check out
http://www.mvps.org/access/forms/frm0028.htm)
or populating the field in the underlying table with a given value based on
the first ... if so, then you don't want a combo box as the second field a
text box will do.

if you'ld like to provide more details, maybe type out an example or two in
your reply we'll be able to assist more.

Cheers
JulieD

I have 2 bound combo boxes in a form. I am trying to automatically put a

set value in the 2nd combo box according to what was entered into the first
combo box...please help!