Prevent changing a record

[SAC]

Access 2000

I have a main form with a subform - an invoice.

I would like to be able to lookup old invoices to reprint them, but not
allow additions, edits, or deletions to the invoice.

I have been able to set these for the main form, but I haven't been able to
get it to work for the sub form.

I test for the existance of a posted check on the mainform. If it's true
then I set the subform's allow... properties.

I must not be setting them in the proper event becasue I can still add a row
to the subform. I've tries oncurrent and before insert.

Any ideas on how to do this?

thanks.

 

[Chris Sergent]

You can either use a button, or create a copy of your form
and in form properties, set Allow Edits to False.

 

[SAC]

Where do I put the code for the subform?

You can either use a button, or create a copy of your form
and in form properties, set Allow Edits to False.