old records be read only

[Guest]

How do I make all records on a form [except for a new record] become
non-editable; even associated records in other tables non-editable.

example: [table invoice], [table products], [table products-to-invoice]
[form main]: has invoice information and a subform
[subform products-in-invoice]: can add products on an invoice
I want my form to make a new record and add products to it; or view old
records (without editing or adding a product)

 

[Allen Browne]

Set these properties for your form:
Allow Edits No
Allow Deletions No
Allow Additions Yes
Data Entry No

That might cause your subforms to be locked as well (i.e. they don't allow
new entries.) If that is a problem, the alternative would be to use the
Current event of each form to loop through its controls and set their Locked
property based on the NewRecord property of the form. You would need to do
this in each subform separately. Post back if you need more details of this,
and you are comfortable with using code.