ComboBox output depends on another won't work

[ArkBob]

I have a cbo pulling primary listing and then another cbo pulling info based
on the first cbo. I works the first time correctly but if I change the
selection in the first cbo the inform displayed in the second cbo does not
change. How do I force the second cbo to re-query based on the changed input
from the first?

Thanks

 

[strive4peace]

on the AfterUpdate event of the first combo:

'~~~~~~~~~~
me.combo2_controlname.Requery
me.combo2_controlname = null
'~~~~~~~~~~

the reason you want to clear the second combo is because if it has a
value that doesn't match the new criteria, it will not show and the user
will not realize it is filled out!

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[ArkBob]

Thank you very much! Worked great.

on the AfterUpdate event of the first combo:

'~~~~~~~~~~
me.combo2_controlname.Requery
me.combo2_controlname = null
'~~~~~~~~~~

the reason you want to clear the second combo is because if it has a
value that doesn't match the new criteria, it will not show and the user
will not realize it is filled out!

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[strive4peace]

you're welcome, Bob happy to help

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*