Auto Fill within a Subform

I have a form that displays a dealer and a subform that displays their
customers. In this subform there can be 1-1000 records. I am going to call
each dealer and ask for each customers paperwork. I need to record for each
individual record (in the subform) that I asked for that customer's
paperwork. I have a checkbox in the subform for each individual account but
I don't want to go through 1 to 1000 records and check inside the checkbox.

Any easy way to have these checkbox's checked automatically?

NG,

An update query will do it. Assuming there is a DealerID in each customer
record tying them to the dealer:

UPDATE YourTable SET YourTable.YourField = True
WHERE DealerID = YourValue;

Hope that helps.
Sprinks

"NG" wrote:

I have a form that displays a dealer and a subform that displays their
customers. In this subform there can be 1-1000 records. I am going to call
each dealer and ask for each customers paperwork. I need to record for each
individual record (in the subform) that I asked for that customer's
paperwork. I have a checkbox in the subform for each individual account but
I don't want to go through 1 to 1000 records and check inside the checkbox.

Any easy way to have these checkbox's checked automatically?