V
vmf
I have a Production data entry form with a subform that updates a Detail
table. There are 2 fields on the main form, number of cards and number of
accounts, that I need to autofill based on the values of the subform. Three
fields are common to both forms, Batch, Date, & WorkType. If the data entry
clerk enters a Batch, Date, & WorkType combination contained in the subform,
I want the cards & accounts fields on the Main form to be automatically
populated with the values from the cards & accounts fields of the subform. I
do, however, want the user to be able to overwrite these autofill numbers if
desired.
How do I write the code to say that if batch, date, & work type field values
in Main form = batch, date, & work type field values in the subform, then
populate the Main form cards & accounts fields with the value in the subform
cards & accounts fields. I am using Access 2000. Thank you for your help.
table. There are 2 fields on the main form, number of cards and number of
accounts, that I need to autofill based on the values of the subform. Three
fields are common to both forms, Batch, Date, & WorkType. If the data entry
clerk enters a Batch, Date, & WorkType combination contained in the subform,
I want the cards & accounts fields on the Main form to be automatically
populated with the values from the cards & accounts fields of the subform. I
do, however, want the user to be able to overwrite these autofill numbers if
desired.
How do I write the code to say that if batch, date, & work type field values
in Main form = batch, date, & work type field values in the subform, then
populate the Main form cards & accounts fields with the value in the subform
cards & accounts fields. I am using Access 2000. Thank you for your help.