N
Nylex
I have a form “Orders†with a subform “OrderDetailsâ€
I enter the details and everything works fine – Gets the pricing from
Products file and the Clients name and Address from the Clients File
The entries are entered into a table “Orders†and “OrderDetails†and the
link field is “OrderIDâ€
My next step is to print out the Order
I have a report “Client Order†and it works fine and is laid out the way we
want it to but it prints out every record in the system when started
I start it with a Command Button on the Order form and a Macro runs - I only
want to print the Order I am currently looking at
Macro
Report Name Client Order
View Print Preview
Where Condition "[OrderID]=" & [Forms]![Orders]![OrderID]
How do I make the Filter work
I enter the details and everything works fine – Gets the pricing from
Products file and the Clients name and Address from the Clients File
The entries are entered into a table “Orders†and “OrderDetails†and the
link field is “OrderIDâ€
My next step is to print out the Order
I have a report “Client Order†and it works fine and is laid out the way we
want it to but it prints out every record in the system when started
I start it with a Command Button on the Order form and a Macro runs - I only
want to print the Order I am currently looking at
Macro
Report Name Client Order
View Print Preview
Where Condition "[OrderID]=" & [Forms]![Orders]![OrderID]
How do I make the Filter work