Mr

[Abdulaym]

Hi, I have 2 questions?
1. printing invoice through report and each report for every customer should be on a separate page and show the current customer records for printing?



2. How do I print records from subform. Because I want to continue to use the CustomerID for each customer. So how do I print a specific records in the subform. For example yesterday customer older 1. Rice 2. Beans and also come back today and order 3. Milk 4. Rice. So how do I print today and yesterday order from subform. Your response will highly help Thanks

[Minty]

I appreciate English is probably not your native language, but can you please give your threads a sensible title - Mr - gives us no context or clue what your question is about.

Secondly, Can you give some examples of the code you have used and what you are struggling to make work.
A picture of a form with and some pointers, or even better, a sample database with instructions on how to replicate the problem.
A picture of your tables and relationships would also help.

At the moment we have nothing to work with, no report names, no idea how you are opening the report etc. etc.
For us to help you, you must help us a little.

[mike60smart]

Hi
If you have a Main Form linked to a Subform
Then you need a query containing required fields from Both the Customer and Items tables.
Then you are able to create a Report based on this query which would allow you to filter the required data.