I'm printing a report matching results entered on a form.
From a company form you click a cmd button. Another form comes up with the customer name you enter dates to search between from.
Click print report cmd button macro runs a "make table query" and opens another form to allow edits. I make the table because I dont want any edits made to be permanent.
Heres the problem and I dont understand it.
After you pick your dates and open the "make table query" everything runs fine except for the fact that it changes the first customer listed in the customer table to the customer name that you're doing the search for.
The customer table is
the table being made is called
It's just picking the fist customer listed in the tblCustomer and changing it to whatever customer you're using to search for and make the tblSvcReport.