Print report with form data?! Help Please.

[Wakin]

Hello, so i've made a fully functional form, and i copied the layout of the form into a report, and i wanted to know if its possible to print the report of the form(Client data etc) with a button, or with code, since im not able to. Thank you so much.

[ranman256]

Docmd.printForm

[Bulzie]

On the Form, you should be able to add a button(Design mode, Controls, look for the button and add to the form in header or foogter) which will start the wizard where you can go through the options to have the button print your report.

[Wakin]

But imagine, I want to select One contact and print that form as a report, is that possible?

I've done that Bulzie, and no success

[Bulzie]

Not sure your form layout but I assume on your form you are looking at one contact at a time and assume you have the ContactID or number(unique value) on that form. If so, then in the query on your report(if it is a table make the Recordsource a query, add all the fields and in the ContactID field criteria, add Forms!frmYourForm!ContactaID or whatever your field is called. This way when the report is run it will only pull data for the Contact you are viewing on the form.

Another way to get the criteria field syntax is to right click in the criteria box, select build, select forms and then keep drilling down until you find your form and the field ContactID or whatever it is called and double click, it will put the right reference to that field in your criteria box.