I wish to print one record, using a report, while viewing my data with a form.

Essentially, I'm trying to place a button/control on a form, that will invoke my macro/report, & print the one-page report of fields from the CURRENT RECORD being viewed on the form. The report is a simple mailing lable.

I just can't figure out how to invoke the report, from within the FORM, such that it selects & prints only the info from the CURRENT RECORD being viewed on the form.

I have the database, the tables, the form, the report (a mailing label), And a working lable printer! All the parts work, separately: the form, the lable-report, the printer -- but I can't seem to put them together to print only one, CURRENT record being viewed.

Can anyone help me crack this nut?
Thanks. Chas, stumped in Rockville MD.

See Microsoft Knowledge Base article 209560.

VanTheinDinh -- Thank you so much for directing me to this article in the MS knowledgebase. This is exactly my situation, and this appears to be exactly the solution that I need. I'll let you know how it turns out.
Thanks again. ckelly in Rockville MD.

You re welcome... Glad to help...

Post back if you need help implementing the MSKB technique.