Select/Change values of previous records

[Jeff]

=====
ISSUE
=====
1-How do I select/change the value of fields in ALL PREVIOUS records
(of a subform/continuous forms) upon clicking command button of
current record (of subform).



=======
EXAMPLE
=======

Before Clicking "CommandButton1"

Form
SubForm (Continuous Forms)
Record1 Yes Yes CommandButton1
Record2 Yes Yes CommandButton1
Record3 Yes Yes CommandButton1



**After Clicking "CommandButton1", ON RECORD3, I want this...

Form
SubForm (Continuous Forms)
Record1 No No CommandButton1
Record2 No No CommandButton1
Record3 Yes Yes CommandButton1




==========
BACKGROUND
==========
O/S = Win 2000 Pro
Patches Installed

Software = Access 2000
Patches Installed


=========
Thanks!!!
THE END
=========

 

[John Vinson]

=====
ISSUE
=====
1-How do I select/change the value of fields in ALL PREVIOUS records
(of a subform/continuous forms) upon clicking command button of
current record (of subform).

Two concerns here:

- Subforms do not contain data. They are windows which DISPLAY data;
that data *is in a Table* (or tables), and if you want to update data
in a Table, you should use an Update query.

- In a Table there are no "previous records" or "next records" - a
Table is an unordered "bag" of data. If you want to update a
particular subset of records you need criteria on your Update query
which identifies them - perhaps the Master Link Field of the subform,
with other criteria to limit the records to the "previous" ones would
work.

I'm curious what you're trying to accomplish here! Ordinarily in a
properly normalized table design, each record is dependent only upon
its own Primary Key, and changing a value in one record would not
cause other records to need updating. What's actually going on?