Opening a report from a form command

[undee69]

Good day everyone,

I want to open my report to named DeliveryNote by clicking a button. I used VBA command docmd.openreport to open it up. But what I want it to show are the same items shown on the form below.




When I open open the report, it shows all the records

[alansidman]

Here is an example that I have used in the past.

[undee69]

Thanks a lot dude ^_^ I will try this out and met you know if I got it working on my end ^_^

[undee69]

thanks for this one dude. I just made sure that I have the correct master and child linked ^_^

[DariusD]

I like what I see Undee69.. How did you get your report to show one invoice? I have a project I am trying to help my son complete for a program he is trying to getinto for High school. The problem I'm having is getting a report to print that shows one order/invoice at a time, as opposed to every order/invoice all at once. Note how you show only one invoice above..Im sure your table has a bunce of invoices yet you are able to show just one per page in your report.. How did you do that.. and How do you get a button to perform that action.. Need to finish this by tonight.

Here is my form view.. and the report I created that I dont like..I am also attaching my database since the information is not sensative..thanks for your help