Update Table with Continuous Form

S

Sash

I have an SQL statement that takes a calculation from my form and updates the
table with that value and it works. However, I'd like to view the form in
continuous and have it update for each iteration, but it seems to be placing
the value of record 1 in field for all 15 records. Any suggestions? Is
there maybe a way to have the default value in the table be a calculation of
two fields? Sorry kinda new.
 
S

Stefan B Rusynko

You would need to add code to your processing page to loop thru all records and
- call the fields used for calculatation, calculate a result, and then update that record

rs.movefirst ' start w/ 1st record in the set called
do while not rs.eof
' Your code to do the calc & update that rs goes here
rs.movenext 'Get next record
loop





|I have an SQL statement that takes a calculation from my form and updates the
| table with that value and it works. However, I'd like to view the form in
| continuous and have it update for each iteration, but it seems to be placing
| the value of record 1 in field for all 15 records. Any suggestions? Is
| there maybe a way to have the default value in the table be a calculation of
| two fields? Sorry kinda new.
 
Top