Closing date? to protect history record.... (1 Viewer)

[Yu2008]

Hi, I am looking for a code that can allow me to enter a closing date on the Warehouse database, so the person who do the warehouse data entry (in Front End) can't change any of the figure that had entered before the closing date (unless I enter the password to change the closing date or release it) but free to enter the data right after the closing date.

Can anyone help me? I'd really appreciate it. Have been searching this for couple hours. But no clue...

 

[apr pillai]

Closing Date

If me.closingDate >0 and me.ClosingDate <=Date() then
Me.AllowEdit = True
else
Me.AllowEdit = False
end if

 

[Aeon.Divine]

Ar maybe just to lock the field, cause using allowedit you wont be able to edit nothing in the form. If you just want to protect the date textbox try:

Me.Textboxname.locked = True

And thats it. Hope it'll come in handy.

 

[Yu2008]

Hi thanks! I'll try both ways.

Yu

 

[Yu2008]

Hi Thanks! here is my final code:

If Me.Dates < Me.ClosingDate Then
Me.Quantity.Locked = True
'The following statement shows a message box.
MsgBox "Sorry! You can only change data after the closing date."
Else
Me.Quantity.Locked = False
End If