Conditionally available checkbox

[lisaharris]

Is there a way to lock (or hide) a checkbox if the contents of another field is not null?

On one form, I have a processing date and a delete checkbox along with other information. If the item has been processed (in which case the processing date is filled in), I want the checkbox to be disabled or hidden.

__________
Veni, Vidi, Visa: I came, I saw, I charged it.

 

[randy700]

Something like this?

If DateField = spaces or DateField Is Null Then
    Me.Checkboxname.Visible = False
Else
    Me.Checkboxname.Visible = True
End If

Randy

 

[PHV]

Me![delete checkbox].Visible = Not(IsDate(Me![date control]))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886