"Hero" needed for help with Access Forms!!!

[Felix_too]

I have set up a form to show data held within a table named "Customers". This form contains a subform named "Invoices" which shows data held within a table named "Invoices". This subform shows all the invoices related to each customer and has a 1 (Customers) to many (invoices) relationship. So when I click through each customer, in the subform I can see all the invoices related to that particular customer.



... So far so good!...

What I now want to do is to add a button next to the invoice line that when clicked, will print out just that particular (single) invoice... NOT ALL THE INVOICES! - which is what it wants to do!!!

I have designed a report to use for this purpose (which is also named "Invoices") and I can get as far as setting up a button that when clicked, prints off ALL invoices, but not just that single one.

I must make it clear here that I am NOT in anyway an expert with Access and my knowledge is limited to only making up tables and straightforward forms and I have no programming ability.

If you can give me step by step (idiot proof) instructions on how to set this up, I would be eternally grateful!... because it's now starting to do my head in! :-(

Yours hopefully... Tony Law

[pbaldy]

This should work, using OpenReport instead of OpenForm:

BaldyWeb wherecondition

If you need help on where to put the code:

http://www.baldyweb.com/FirstVBA.htm

[ajetrumpet]

Paul's the hero!!!

[Access_Blaster]

This could also help
http://allenbrowne.com/casu-15.html

[Access_Blaster]

Oops saved twice.

[Felix_too]

Thank you all for your help, however the "Hero" award goes to... <<<Drum Roll>>> ... Access Blaster!!! After 18 hours of trying to sort this, your post got me there.

Thanks for digging me out of this hole :-)

[Access_Blaster]

Allen Browne is the real Hero. Glad it worked out.