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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DISPLAY TEXT BOX & LABEL ON CONDITION

Status
Not open for further replies.

ajdesigns

Technical User
Jan 26, 2001
154
GB
Is ther any way I can set a text box and its label to display conditionaly.
I have a form that has a combo box with the options Project, submitted, accepted, rejected, parked. when one of these options are chosen the user needs to enter the date in a text box.I only want this text box to be visable when the user chooses Submitted or Rejected in the combo box otherwise I want it to be invisable .
Is there a way I can do this.
 
Yes, in the AfterUpdate event procedure of the combo.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Thanks PHV.
I have never written an event procedure before, any help on how I would get the text box to display when the combo is submitted or rejected.At the moment i have got(not a lot)

Private Sub Status_AfterUpdate()

End Sub
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top