Combo Box Values not Changing

[weircolin]

Hi

I hope this makes sense.

I have two combo boxes where the second one is dependent on the first
ones value.

For some reason when I have the form open and looking through the data
already entered the second combo box is not displaying the proper
choices from the first selection.

Does anyone have any idea on how to fix this? Is it just a case of
putting some info into the form load event?

Thanks

Colin

 

[weircolin]

Sorry, I also meant to say that on the largest part as I go through the
form with the entries, the second combo box is blank.

Colin

 

[Douglas J. Steele]

Are you forcing a requery of the 2nd combo box when the 1st combo box
changes? You probably need to put this in the form's Current event as well.

 

[weircolin]

Hi Doug

Thanks for your reply.

Yes, its forcing a query. How would I go about putting that into the
current event?

 

[Douglas J. Steele]

Essentially, you'd use the same code you've got in the AfterUpdate of the
1st combo box into the Current event. Typically what I do is have the
current event call the AfterUpdate event of the 1st combo box (or else
create a separate module that does the requery, and call it from both
places). That way, if something changes, you only have to change the code
in one place.