Multiple records that contain a checkbox.One record should be

Multiple records that contain a checkbox.One record should be

Post by QlpleWdlc » Wed, 07 Oct 2009 03:03:18


txtActive is a bound control....all of the fields are. Sorry I forgot to
mention that.
It is bound to a table (TableInfo).

Example:

Active Name Amount
Test1 $150
X Test2 $200
Test3 $300

Only one active field at a time. The user has the abilty to modifiy data in
the form view.
 
 
 

Multiple records that contain a checkbox.One record should be

Post by S0FSTCBERV » Wed, 07 Oct 2009 03:19:27

UNTESTED UNTESTED
You might try an update query to update all txtActive as 0 (zero) in the
BeforeUpdate event of the object used to display txtActive.

--
Build a little, test a little.