G
Guest
I have a form based on a select criteria, and would like to limit the amount
of data available to the form. The query returns multiple records, and I
need to limit the number returned based on the output of one of the fields, a
Ship To Address. I need to pass only those records that have the same ship
to address to the form. This is used to create invoices, and this particular
client of mine generates a new invoice for each ship to address. (IE: Job
Site, Customer Shop, Customer Pickup, etc.) I would like to filter these
records in the query itself before opening the form. Any and all assistance
and suggestions are greatly appreciated!! Thanks in advance-Craig Z
of data available to the form. The query returns multiple records, and I
need to limit the number returned based on the output of one of the fields, a
Ship To Address. I need to pass only those records that have the same ship
to address to the form. This is used to create invoices, and this particular
client of mine generates a new invoice for each ship to address. (IE: Job
Site, Customer Shop, Customer Pickup, etc.) I would like to filter these
records in the query itself before opening the form. Any and all assistance
and suggestions are greatly appreciated!! Thanks in advance-Craig Z