Gossamer Forum
Home : General : Databases and SQL :

Re: [zenners] Disabling Fields on Form

Quote Reply
Re: [zenners] Disabling Fields on Form In reply to
Sounds to me like you'll need to create corresponding bit fields to those columns that you don't want edited after they calculate them.

Example:

CalcField1 = 100
CalcFieldEdited = 1

Basically, use a bit (1/0 value) for those corresponding field. As soon as the form is submitted, check the values inputted and calculated, then SET the corresponding trigger field/column to 0, meaning cannot edit.

Then in the calculate form, you'll need to add conditions in your WHERE clause that you use to build the form.
========================================
Buh Bye!

Cheers,
Me
Subject Author Views Date
Thread Disabling Fields on Form zenners 5571 Nov 8, 2002, 10:22 AM
Thread Re: [zenners] Disabling Fields on Form
Stealth 5322 Nov 8, 2002, 12:27 PM
Post Re: [Stealth] Disabling Fields on Form
zenners 5297 Nov 8, 2002, 3:28 PM