dont allow record edits after a certain date

[krberube]

Hi all,
I have a form that is used to Enter and Edit records. At the end of a record is a "shipped Date". This is blank until the item ships. I want to make the entire record editable up until a date gets placed in this field. Is this possible? and can editing of the record still be done maybe at the table level?

Thanks

 

[grnegsndhm]

Onload of the form you could set all the elements to enabled = false if the Shipped field is < than now()?

 

[krberube]

sounds like you have the answer , though I'm not sure where/how this would be done.

Thanks

 

[grnegsndhm]

Open up the form in Design View
Right click the left corner of the form (see a black square) and select properties
Go to teh Events Tab
Go to the Event "On Current" and click the "..." to the right of the text area on that line
Select Code Builder

Okay. Here is where you will put then meat.

Determine the name of the control of the form that has the shipped date

if me.ShippedDate < now then
' Disable each other control on the form
If Me.somedate < Now Then
Me.desc.Enabled = False
Else
Me.desc.Enabled = True
End If
end if

You may need to play around with this a little.