Require date based on a drop down

L

LKnomad

I have a drop down menu that allows a yes or no selection. I also have
a text box for a date. I would like to require the text box to have a
date if the drop down is set to yes.

To further explain. The drop down is stating if an order has been
sent. If yes then I need the date added. If no then no date necessary.
It would also be nice if the drop down is set to yes then the date
would automatically set to today but ONLY if it is empty. If the date
text box already has a value then it is left alone.

Thanks

Laura K
 
J

Jeff Boyce

Laura

You don't mention what you've already tried...

Consider adding code in the combo box's AfterUpdate event to set the text
box's .Enabled property to True or False. You could also use this to set
the value of the field to Date() if it has nothing in it.

Good luck

Jeff Boyce
<Access MVP>
 
Top