Printing Labels

[gregorg]

Question for access forum

Hi i have a database for a vets, and i have to print labels for them for the medicine.
The main form has all the patient details and drug details. I have tp produce a report i guess and populate it with details from the main form and from an inputbox (drug amount).
So I DoCmd.OpenReport to open the report that will be the label for the bottle but i need to populate the report with details form the main form and from an inputbox and I don’t know how to do this.
The report is not based on a table, but is just built from the main form and from details from an input box. So I am guessing i use a clause in the openreport statement to populate the report. But I amnot sure how to do this as the report is not based on a table.

Also i was wondering if the openreport statement can send the peport straight to the printer without opening it on the screen first, this would be to cut down the number of buttons the user need to press to get the label to print.
Also I don’t even know if using a report is the best way to print labels, but i guess it was the best way.

I was thinking -- docmd.openreport Name, , Details of Contols to fill from main form and inputbox, ,



Thanks, GregorG.

 

[Trevor G]

If you have named each object on the form you can use the same names in the data source for each control on your report.

Have you used the Label Wizard in the Access application

Microsoft also provides a sample database for creating reports which does include labels.

Look at this link.

http://www.microsoft.com/downloads/...A5-C76F-4EDA-BC9A-5FAC336EF7F1&displaylang=en

 

[gregorg]

Thanks very much.