Combo box hell again

[Guest]

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

 

[Duane Hookom]

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

 

[AccessVandal via AccessMonster.com]

At the cmbo 1 event, add this,

Me.cmbo2.Requery

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