Locking Field Records

[nishant.dhruve]

Hi
So as you can see, i want to lock the field SOPDATE which is already filled in with date but i want to allow my user to enter data in the field where its empty.


is there any way to do this

[ranman256]

you cannot lock/ unlock separate rows,
all dates are locked, or all unlocked.
when user selects the record, THEN you can determine whether to lock it or not.

event when user changes records:

sub form_onCurrent()
  txtDate.locked = not IsNull(txtDate)
end sub

[Homegrownandy]

Or have an event that puts the date in to todays date. Assuming you want that date.

[ssanfu]

You could use the current event to lock/unlock a field or fields.
You move to a record, the current event fires checking the value of the specific field(s). If the field has a date, lock the field, otherwise unlock the field.