Combo box hell again

J

Joe C

Ok, I have two combo boxes. The second is based on the selection in the
first. It works. I select a value that is a subset of cmbo 1 in cmbo 2. Once
I do that Irun a report on the two values.

It works great, ONCE!!! When I go back to the form and reselect a value in
cmbo 1 it does not re-populate cmbo 2 with the appropriate value.

Any clues.

Thanks
Joe
 
D

Duane Hookom

I think you forgot to tell us anything about your combo box properties
and/or code.
 
A

AccessVandal via AccessMonster.com

At the cmbo 1 event, add this,

Me.cmbo2.Requery

Joe said:
Ok, I have two combo boxes. The second is based on the selection in the
first. It works. I select a value that is a subset of cmbo 1 in cmbo 2. Once
I do that Irun a report on the two values.

It works great, ONCE!!! When I go back to the form and reselect a value in
cmbo 1 it does not re-populate cmbo 2 with the appropriate value.

Any clues.

Thanks
Joe
Click to expand...
 
Top