disable dataentry if date < today

G

Guest

I have a form in which I would like to disable data entry into a record if
the record date is < today.

Thanks
 
D

Dragon

Enter following code into your form's 'On Current' event. Adjust
accordingly.

If MyDate < Date Then
AllowEdits = False
Else
AllowEdits = True
End If
 
G

Guest

thanks

Dragon said:
Enter following code into your form's 'On Current' event. Adjust
accordingly.

If MyDate < Date Then
AllowEdits = False
Else
AllowEdits = True
End If
Click to expand...
 

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

How can I automate the CNTR + " to repeat the data in field / reco 6
BKF - SEARCH for specific record in table via combo box within for 1
Excel Message box with days of month & date. 1
Pivot table macro filter data between yesterday and today (date+time) 0
Access Property sheet data missing also syntax 0
Access Automatically Send a notification email once a record is added 0
Data Entry form 1
Date as a value to a textbox as a result from another textbox 1

Top