Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Disabling Input Based On Yes/No Field Input - Newbie Question

Status
Not open for further replies.

amourdevin

Technical User
Sep 7, 2003
21
US
This is in regard to creating a form. I have two date fields (DateIn & DateOut). I also have a Yes/No field (InStatus). What I would like to do is disable input to the DateIn field when the InStatus field is Yes. I would like to disable input to the DateOut field when the InStatus field is No.

I am a newbie. Details are appreciated.

Thanks in advance!
 
In the afterupdate propery of the Status field, you want an If statement that evaluates Status with action if true.

If Status = Yes Then
Me.DateIn.Enabled=False
EndIf

Hope this helps.

Jim DeGeorge [wavey]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top