Edit Problem on A Form

  • Thread starter Thread starter Aamer
  • Start date Start date
A

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
 
In the properties for the field's control, set the locked
attribute to TRUE. (I didn't have time to test that.)
 
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.
 
Back
Top