D
Database User
I have a customer form with a subform which is linked on customer id. In the
subform there is always 16 records (actions) for each customer exactly the
same and when each action is done i tick Action Successful.
Because each customer gets all the information in the subform exactly the
same i have an excel sheet with all the other fields filled besides for
action successful and everytime i add in new customer i copy the excel sheet
and paste append it into the subform. Is there any way that i can have a
control button to run a macro that when i click it it will automatically fill
the subform with the 16 records?
subform there is always 16 records (actions) for each customer exactly the
same and when each action is done i tick Action Successful.
Because each customer gets all the information in the subform exactly the
same i have an excel sheet with all the other fields filled besides for
action successful and everytime i add in new customer i copy the excel sheet
and paste append it into the subform. Is there any way that i can have a
control button to run a macro that when i click it it will automatically fill
the subform with the 16 records?