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
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