Prevent changing a record

  • Thread starter Thread starter SAC
  • Start date Start date
S

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.
 
You can either use a button, or create a copy of your form
and in form properties, set Allow Edits to False.
 
Chris said:
You can either use a button, or create a copy of your form
and in form properties, set Allow Edits to False.
Click to expand...

Access security could also be used, but it is not easy to get right and
I would guess SAC would be better served with Chris' suggestion.
 
Where do I put the code for the subform?


Chris Sergent said:
You can either use a button, or create a copy of your form
and in form properties, set Allow Edits to False.
Click to expand...
 
Back
Top