enable combobx

[krishnanhemanth]

hi every body
i have 2 comboxes on a bound form
combobox2 is based on combobx1
i want the combox2 to be enabled only if combox1 has a value

please help me

hemanth

 

[John Big Booty]

Try something along the lines of;

If IsNull(Me.combobx1) Then
     Me.combox2.Enabled = False
     Me.combox2.Locked = True
Else
     Me.combox2.Enabled = True
     Me.combox2.Locked = False
End IF

You will need this code in the form's On Current event and also in On Change event of combobx1.

 

[krishnanhemanth]

thanks for the reply

i get an error

runtime error 424

object required


its pointing at form current

 

[John Big Booty]

Have you got the correct Object names for the Combo Boxes?

 

[krishnanhemanth]

objexts name are correct

 

[John Big Booty]

Any chance you can post a copy of your DB? (2003 version if possible) and I'll take a look at it for you.