Batch update from form data

[Guest]

I have a form now calculating a part price (originally done in Excel) and
storing that price in the master file along with the part dimensions. The
price is calculated from many unbound fields that call functions and thus is
not part of the form's underlying query. This is fine except that I need the
ability to do a "batch" update of all the parts when a component's cost
changes. How do I do this in VBA? Thanks for any help!

 

[John Nurick]

You don't say where the unbound fields get their values from. If the
user has to enter the values every time, it seems to me that you should
be storing them - or the values that underlie them - instead of the
price, which should be calculated whenever needed. Then, updating the
"input" values would automatically update the price (as it would in
Excel, of course).

If the unbound fields are getting their data from other tables, the same
principle applies.