Edit Problem on 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

 

[PieterLinden via AccessMonster.com]

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

You need to store the AllowEdits value for the record back in the table.
then add the checkbox to the form (hidden). Then in the OnCurrent event of
the form, do something like

Me.AllowEdits = me.chkAllowEdits

That way, you can lock individual records - but through the form only.