I'm not very VBA saavy, and I'm having a very hard time on figuring something out, so hopefully someone can help me.
I have 2 forms, one called "Information" where you input customer information & this is stored in a table. Then there is another "Main" form which has several command buttons, one of which is to print.
There is a query called "Update to Printed" which updates a check box called "Printed" with a check mark in the "Information" form for those entries that have already been printed.
There is a list box on the "Information" form called "LabelsRequired" that the user will set to the number of copies for that particular entry that they want to print out.
And finally, there is a report, called "Box Label" that will print out on a label the entries which have not yet been printed (via the "Printed" check box.)
My problem is that I cannot figure out how to get all of these parts to work together correctly. I'm not very familar with the commands in VBA. I just need it to print out the number of copies of each label specified in the "LabelsRequired" list box (which could be different for each entry & multiple entries can print out all at once), and then run the "Update to Printed" query afterwards. How can this be done?
Thanks in advance for your help!
I have 2 forms, one called "Information" where you input customer information & this is stored in a table. Then there is another "Main" form which has several command buttons, one of which is to print.
There is a query called "Update to Printed" which updates a check box called "Printed" with a check mark in the "Information" form for those entries that have already been printed.
There is a list box on the "Information" form called "LabelsRequired" that the user will set to the number of copies for that particular entry that they want to print out.
And finally, there is a report, called "Box Label" that will print out on a label the entries which have not yet been printed (via the "Printed" check box.)
My problem is that I cannot figure out how to get all of these parts to work together correctly. I'm not very familar with the commands in VBA. I just need it to print out the number of copies of each label specified in the "LabelsRequired" list box (which could be different for each entry & multiple entries can print out all at once), and then run the "Update to Printed" query afterwards. How can this be done?
Thanks in advance for your help!
