contineous form, full table update

[C. van Kooten]

Access users,

I am using A97. In an application using a contineous form with a
selection of tablerecords, I want to reset a variable for all the
records in the contineous form, if a certain value in one of the records
is entered. How should I program this?

thanks in advance, Cor

 

[JohnFol]

You cannot scope variables at the record level, only module / function etc.
.. .. Do you mean
"If a record contains value x then myvariable = y"

 

[C. van Kooten]

John,

thanks for the reply. What I want is:
suppose on a contineous form, linked to a selection of a table, I have the
following fields

seq entry flag
101 1 1
102 3 1
105 4 1
110 ...

the last is the record in edit. Suppose I enter a 0 to the entry field ..., at
that moment I want all the flag values to be set to 0, resulting in:

seq entry flag
101 1 0
102 3 0
105 4 0
110 0 0





JohnFol schreef: