Button on a Form to make record read only

[billgyrotech]

Can a button be programmed to save current record and make it read only to prevent editing of data in that record. This would be useful so that I can close out a certain record (work order) for a customer.

Thanks,
billgyrotech

[pbaldy]

There would need to be some way of identifying the record to prevent it from being edited. Some would use a status field, or perhaps a closed date (no date means okay to edit). Basically you'd set the allow edits property of the form behind your button and in the current event of the form.

[billgyrotech]

I do have a finished date field. How do I make it work?

[pbaldy]

Along the lines of

If IsDate(Me.FinishedDate) Then
  Me.AllowEdits = False
Else
  Me.AllowEdits = True
End If

[billgyrotech]

I put the code under the DatePickedUp field On Exit Event Procedure but it didn't work. What am I doing wrong?

[pbaldy]

No idea, since I don't know what "didn't work" means. Error, wrong result, or ?

I'd have it in the after update event of the control, and the current event.

[billgyrotech]

I have the file attached. On the subform Workorder there is a DatePickedUp field that I tried to enter the code, but it doesn't make the data read only on the form for the current record.

[pbaldy]

I'll try to look at it tonight. I only have 2000 on this machine and I turned off my laptop with VM's for other versions on it. Heading out to see a movie with my daughter anyway.

[billgyrotech]

Thanks for any help! Have a great night!