Form print button

[coyrob2010]

Hello, I have created a database in a split form design to receiving incoming products...it is working very well. However, needing to keep this simple because IT resources are scarce where I work. I have a need to for a print button on my form; to be able print on a standard 4 x 6 shipping label. Keeping it simple I would like to find a way to size the form area (as seen on the screen) to be printed directly on the label, I can get it to print on a standard sheet of paper, but having trouble for the label. Also, I need it to print just the select record as show on my form. Is this possible without using VBA?

[June7]

It would be easier to design a report to print the shipping label. Forms are intended for screen presentation of data, reports are intended for printing.

[coyrob2010]

Thank you very much...I have the report set up to print to a 4 x 6 shipping label. I thought this part would be easier...when I created the print button on the form (using the wizard) I selected it to print report. When testing it want to print all records on the report (which is displayed in print preview). I checked the properties the embedded macro reads "Open Report" View Report, Window mode Normal, then "Print Object". Can you please help me with some better settings? Thank you in advance. coyrob2010

[June7]

If you want to print only one record then need to set filter criteria for the report. Several ways to do that. I don't use macros (only VBA) but I expect the OpenReport macro has a way to do that.

Another approach is parameterized query as the report RecordSource http://datapigtechnologies.com/flash...mtoreport.html