Printing from a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to have a small form that I could use to print a set of user
selectable data from. Example: print all the invoices for customer X from
date A to date B.
I have one that is working sortof. It prints what I want but for some reason
it replaces the first record in the customer table with the name of the
chosen customer.
I have not worked with Access for about a year now and need a short overview
of the correct way to do this subset print and any suggestions as to what may
be wrong with my current form.

Thank you!
Dan
 
Either use a query behind it that reads from the form, or put the SQL
in the "On Click" property of the button. It will read Customer X,
Date A and Date B and filter the table based on what's on the form.
 
well yes; that's sortof what I did but my sql query is in the report not the
click button and it uses field data from the form to limit the query. So my
"on click" calls the report via a macro. But the problem I am having is that
the form when used changes the first record in my customer table. When using
the form, the customer is selected with a pulldown box linked to the customer
table. All it takes to over write the correct infomation in my customer table
is for the user to use the drop down and select a customer name and then
click on the print button. The report is fine, I just want to stop the form
from "hammering" my first customer table record.
Dan
 
Back
Top