Printing from a form

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

Guest

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
 
If it's linked, it's going to change your data. You can have it read
from a non-updateable query instead, this way it will display the info
but not allow you to change it.
 
here is the current query used in the form:

SELECT bin.PickedDate, Grower.[Company name], bin.bclass, bin.producevariety
FROM Grower INNER JOIN bin ON Grower.ID=bin.ID;

how would I make it "non-updatable"? and how do I find out if the form is
"linked" and there for, un-link it?
(grower is similar to "customer" and bin is similar to "invoice")

thanks "ManningFan"!
 
Back
Top