If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Auto Fill within a Subform
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? |
Thread Tools | |
Display Modes | |
|
|