Edit Problem on A Form

[Aamer]

I am trying to lock the data after update but am un-sucessful so far

On a form I select Company Name and it is stored in Invoice Table
On the sub form I select the transaction which picks up the transactions
from SALES Table.

I have tried going in the properties of the Main Form and selected ALLOW
EDITS to No

but when I do this I cannot add any Company Name.

is there any other way if once the Company is added it cannot be changed

 

[Bill]

In the properties for the field's control, set the locked
attribute to TRUE. (I didn't have time to test that.)

 

[Aamer]

I did that and it just locks it up which means I cannot use it any more


this did not help

 

[Bill]

What do you mean by "cannot use it anymore"?
You should only lock it during the period that
you don't want it changed. I.e., be sure to
un-lock when you open the form or otherwise
initiate a new action where it "needs" to be
un-locked.