Update All Records in a Table from a Form

[P5C768]

Is there a way to update all records in a table with the information currently entered on a form in single form view (bound form that updates the table whe the form is updated). For example, when I'm on the form, I see a single record at a time, but I would like to have a button that updates all records in the table when clicked.



Do I need to cycle through each record in a loop or is there something like all.field I could use (as opposed to me.field, which is used to only update the current record)?

[pbaldy]

You could execute an update query:

UPDATE TableName
SET FieldName = Forms!FormName.TextboxName

[P5C768]

I should have clarified, the two fields that I am trying to have updated are calculated fields based on two other fields on the form (field1*field2*0.85). I only recently added these fields for users. When they create new records, the after update event of either of the two fields needed calls a module that performs the calculation and updates the field I want to store the result in.

Now I'm trying to go through and update records that were entered before I made this change, without going through each record.

[pbaldy]

I would probably not store a calculated field. You're seeing one reason why. If you really want to, you can still use an update query:

SET FieldName = field1*field2*0.85

or whatever is appropriate to your situation.