dis-allow record edits

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form used for Enter & Edit of records. If the record status is
"Shipped" I no longer want the record to be editable. Is this possible?

Thanks
Kevin
 
krberube said:
I have a form used for Enter & Edit of records. If the record status
is "Shipped" I no longer want the record to be editable. Is this
possible?

Thanks
Kevin
Click to expand...

In the Current event of the form...

Me.AllowEdits = (Me.Status <> "Shipped")
 
Thanks Rick, It makes sense but...when I place this is the current event for
my form, then open a record I receive a "macro "me." not found message.
I'm sure I'm just spacing it... any ideas

Thanks
 
I put the following in the current event procedure and it works great.
Thanks again

Private Sub Form_Current()
If Me.Status <> "SHIPPED" Then
Me.AllowEdits = True
Else
Me.AllowEdits = False
End If
End Sub
 
Back
Top