Changing combo box

M

Maracay

Hi gurus,

I have a combo box, cmbCountry, I shouldn’t be able to modify the data in
this combo box if the texbox txtState have some data, if txtState is empty if
ok to modify the data in cmbCountry.

Thanks
 
R

Rick Brandt

Hi gurus,

I have a combo box, cmbCountry, I shouldn’t be able to modify the data
in this combo box if the texbox txtState have some data, if txtState is
empty if ok to modify the data in cmbCountry.

Thanks

Me.cmbCountry.Locked = Not IsNull(me.txtState)

You need to run that code in both the Current event of the form and the
AfterUpdate event of the txtState control.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top