Hi everyone and anyone, i have a form in Access named "Invoice" which store information for each particular invoice. After filling in the particular detail of an invoice, I want to click on a button "Create Invoice" to open a word document so that i can perform the mail merge function to select the Invoice Data from access and then convert it into PDF file and lastly save it as a Invoice file like INV0100 - P85037,
That's mean each Invoice record in Access form will have 1 Invoice file. After the invoice file is created, I want to click on "View Invoice" button to view the invoice being created just now. For example, for the Invoice record of the Invoice form with Invoice ID INV0100, if I click on "View Invoice" button, the INV0100 - P85037 will appear and so on.
I have google around to find the solutions, but I just can't get exactly what I want. Anyone has the solution please? Many Thanks.