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.