Results 1 to 1 of 1

Thread: Wierd one

  1. #1
    Join Date
    Oct 2004
    Posts
    29

    Unhappy Unanswered: Wierd one

    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
    tblCustomer
    the table being made is called
    tblSvcReport
    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.
    Last edited by chrisn6104; 01-17-05 at 18:56.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •