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

 

[quest4]

Yes, that is one way, but I like to make them invisable till a certain control is filled in. In the form's OnCurrent event, add something like:
If Len(Nz(Me.MyDateControlName, "")) = 0 Then
Me.MyComboBoxConrolName.Visible = False
Else
Me.MyComboBoxConrolName.Visible = True
End If
You must subsitute Your Control Names and you can have as many comb/text boxes as you like. hth.