locking data in subform after record save

[Nixx1401]

I would like the data in a subform to be locked once record is saved, I am entering money received and spent for individuals and I want that once deposited amt and withdrawal amt is entered I do not want these entries to be changed. This info is in a subform.

[RuralGuy]

...and if the wrong amount is entered in error and saved?

[Nixx1401]

I guess I would have to allow only the administrator to edit but all others enter and view data.

Unless you have a better suggestion

[RuralGuy]

If hanky-panky may be going on then maybe a temp table for the SubForm and append to regular table when the user exits the main form setting the "Admin Only" flag in the record as you append.

[Nixx1401]

can you elaborate some more. How should I attempt to do this

[RuralGuy]

I would add a field called something like AdminOnly as a true/false field. You can then set this true when the record is saved in your current scheme and not allow editing if true. Do you know how to create a temporary table for your SubForm to use?

[Nixx1401]

No I don't know how to create a temp table

[RuralGuy]

Do you think you might want to go the temp table route? Do you understand the concept?

[Nixx1401]

I am taking your advice. Dont understand the concept but if you explain I should be able to get it done.

[RuralGuy]

What is the RecordSource of your SubForm and to what do you have the LinkChild/MasterFields set?

[Nixx1401]

Link Child Field is strInmatesID and source object frmTransactions

[RuralGuy]

What is the RecordSource of the SubForm?

[Nixx1401]

record source is frmTransactions

[RuralGuy]

I meant the SubForm and not the SubFormControl. What is the RecordSource of the frmTransactions form?

[Nixx1401]

tblTransactions is the Record Source