Hello,

I have a question, I am making a database with an invoice system.

Users should be able to change the invoice, but at a certain moment (when they push a button or when something else happens) The invoice should be frozen, people shouldn't be allowed to change it nomore. What is the best (easiest) way to do this?

Should I just direct them to another layout where no fields can be changed or are there better ways to do that?

Hope someone can help me,

Thanks anyway,

Greetings,

Thierry

Have a number field called "Lock" with auto entered value of 1. Have all fields in the invoice validate against that "Lock" field. When you are ready to lock the invoice, have that field change to 0. Thereafter no field validating against it can be changed. This is the essence of the Boolean test for validation.

HTH

Old Advance Man

Indeed it works,

Thanks for your help,

Rather young and not so advanced man,.....

Thierry

[ March 15, 2002, 06:14 AM: Message edited by: thierry.be ]