Update Table with Continuous Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Updating inventory levels 0
acnewrec? 1
Update Two Tables Using One Form Contents 0
Access Daily Entry with multiple entries per field 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Enter Parameter Value in Access Form 0
Access Automatically Send a notification email once a record is added 0
Access Create option group without using wizard? 2

Back
Top