Macro Forcing User To Enter Today's Date

[pam_w_85]

Hello,

I am in university and I have an assignment to design a database for a sports centre. I have created the tables and I am now designing the forms. I want to add validation to the forms so that on the booking form the date booked field has to have todays date entered.

I assume that I will need a macro to prevent the user putting in the incorrect date, I selected MsgBox and then using the wizard I created this code –

[Forms]![Membership Info]![Date Joined].[ValidationRule]=Date()

When I enter any date an error message comes up, even when I enter today’s date. Please advise,

Pam

 

[RV]

You're making this far too complicated

Set a default value Date() on your Booking Date
And set the property Enabled to No.

RV

 

[pam_w_85]

Thanks for your help, can you advise on how and can do something similar for Date Of Birth? I want validation so that the member has to be over 16.

Thanks again

Pam

 

[RV]

Similar questions have been asked before quite often.
The forum comes with a search facility, try and you'll find

RV