Disabling a Combobox

[MichelleG]

Just wondered if you might be able to help. I have a form on which I would like to disable some comboboxes until a date box is filled in. Is this possible?

Not too hot with coding - but I have been trying and If Then Else method.

Is this the right way to go?

Thanks
Michelle

 

[MichelleG]

why does this not work??


Private Sub Left_internal_jugular_vein_AfterUpdate()
If Me.Date_of_Neck_USS.Value = Null Then
Me.Left_Innominate_Vein.Enabled = False
Else
Me.Left_Innominate_Vein.Enabled = True
End If

End Sub

Michelle

 

[ejstefl]

It sounds like this should be in the after update event of the Date_of_Neck_USS field.

 

[jrjr]

Try this:

if IsNull (Date_of_Neck_USS.Value ) = true

 

[MichelleG]

Still can't seem to get it to work.

What if I were to say enable these if there is something in the date box? Would that work? ( I wouldn't know how to do it mind!)

 

[jrjr]

Did you set the enabled property of Left_Innominate_Vein to false in the property sheet?

 

[MichelleG]

Well spotted - I had changed it on the wrong control - works like a treat now - thank you all.

Michelle