Automatically fill fields

[libby32]

I have a form based on a table. There is a field that can repeat a number up to 6 times. Ex: Lot Number (Field Name) can be 4 in different records. I want the user to add a value in the form and all records where the lot number is 4 I want this value to update those fields as well..

 

[Fornatian]

Bit slow today, need more info on table structure and what you to update to?

 

[libby32]

Lot Number is a field in my table. There can be the same lot number in different records. For example: the first record in my table can have lot number 1, then the second record can have lot number 1. Users have to key in a weight for each lot number 1. All Lot Number 1's on a certain date will have the same weight. I want the user to have to only key the weight in once for that lot number and have the rest of the weight fields for that lot number to automatically fill in. How can I do this with a form...

 

[Fornatian]

Build a form where the user selects or enters the Lot No Date and Weight for 'today', then use an update query but to update the corresponding records.

Strictly speaking you should consider building a LotNo,TheDate,Weight lookup table to attach to your main table to return the appropriate weight for a certain day by joining on BOTH LotNo and TheDate fields