I am sorry I dont know how to create a query with a filter. here is what i have
table - entry header - primary key - order number
table - order details - no primary key
table - products - primary key - product code
Query - COMBINE ENTRY HEADER & ORDER DETAILS QUERY
Forms - SALES ORDER FORM
Forms - Sales order Subform
Reports - product Labels
i need to filter query (combine) - so when i open my form (sales order) -
hit the command button to print product labels for that one record.
i opened the query (combine) - click filter - filter by form
under look for - there is where i am stuck
I right click and saved that query as "label filter" - no entry are listed -
in design view - i entered
field - COMBINE ENTRY HEADER & ORDER DETAILS QUERY.*
table - combine query
field - SalesOrderNumber
table - combine query
critieria - [REPORTS]![frmCOMBINE ENTRY HEADER & ORDER DETAILS
QUERY]![SALESORDERNumber]
when i click command button is says to enter parameter - sales order number
i am not sure what i am doing. Can you help.
Thanks,
slopes
Jackie L said:
If you are trying to just print the detail for the "invoice" you have
selected, then create a query where the criteria line points to the invoice
you are on. You can do this by using the expression builder and selecting
the field on that form. It would look like:
[Forms]![frmInvoice]![InvoiceNumber]
Then, you can create your form or report with that query as the record
source. Put a button on your invoice form to print the report or open the
next form.
Hope this helps.
SLOPES said:
I am having trouble with filtering a query. I would like to do a "invoice
filter" like in the northwind sample database where it only prints one record
at a time.
i have orders that have several order details attached to them. How can I
filter them so only one record will print.
I figured that a need to set up a command button on the form. the
properties of form needs to set as the invoice filter so it only prints that
particular order details
Can someone help me thanks,
slopes
