Updating a record one time

[Stephen]

I have an Orders Database.

Orders Form, Order Details Subform.

I enter items into the Order Details Subform and each
item has a weight assigned as either actual or estimated.

Basically, I want to force a user to update a record 1
Time that has an estimated weight. Once that Line has
been updated there would be no need to update it again.

Thank you for the assistance.

Stephen

 

[Alan Fisher]

-----Original Message-----
I have an Orders Database.

Orders Form, Order Details Subform.

I enter items into the Order Details Subform and each
item has a weight assigned as either actual or estimated.

Basically, I want to force a user to update a record 1
Time that has an estimated weight. Once that Line has
been updated there would be no need to update it again.

Thank you for the assistance.

Stephen


.
This might not be the best way but it works

on the forms On Current event put in code like this:

If IsNull(Me.YourFieldHere) Then
Me.YourFieldHere.Locked = False
Else
Me.YourFieldHere.Locked = True
End If

If there are multiple fields you might need to get a bit
more creative like:

If (IsNull(Me.YourFieldHere) or IsNull(Me.AnotherField))
Then
Me.YourFieldHere.Locked = False
Me.AnotherField.Locked = False


Else
Me.YourFieldHere.Locked = True
Me.AnotherField.Locked = True

End If