Require date based on a drop down

  • Thread starter Thread starter LKnomad
  • Start date Start date
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
 
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>
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down Date List 1
drop-down based on parameter query 4
return value based on combo box selection 3
Create a Subform to Search Main forms records 3
If "yes" then require data in another field 3
Calculating time 2
Drop Down List Parameter using a Form 3
format date in table 3

Back
Top