How to fill down a series with a value from a textbox

[lccrews]

I have a form with a subform linked to a query. It displays all records related to parameters: Item #, Bill Type, and Revision. I'd like to know if there is a way to type in a value for 'batch size' and, using a button, fill down the series of records with that value. Please see my picture for better clarity.

[lccrews]

A simple update query with batch size being updated to what's in the text box.

[alansidman]

How about an update query using the criteria you have developed for the sub-form.

[June7]

Yes, there are ways. The simplest might be to manually execute an Access dynamic parameterized UPDATE query object. That query object could be called by code (macro or VBA). Or could even build the UPDATE sql entirely within VBA. VBA could even loop through the records on the form and set value in each record (probably the least efficient method).

Why do you need to save this repetitive data? Perhaps you need another parent/child table relationship.