Hi folks,
I don't have a great deal of experience with VBA, but I have a problem with a database which I suspect might be resolved with the use of VBA.
To produce a bunch of customer specific reports, I have a form which has records pertaining to each of the unique customer IDs in the database. I also have a report which, by being linked to a query, will produce a report for the customer ID shown in the appropriate field in the form.
What I would like to do is create a peice of code which will print the specific report, move on to the next record, and then print the next report and so on, until the end of the recordset. Unfortunately, my meagre attempts have been thoroughly unsuccessful thus far.
Can anyone assist (I suspect it would only take two or three lines of code at the most) as I am totally lost here.
Thanks in advance,
B