Changing form for printing.

[Niclas]

Hi all



I admit that this is driving me crazy, but I guess there is an easy solution to it.

I have a database with work orders, and in this database I have two different forms.
One form is for working on the screen, and the other one for printing the work order on a printer.

What I would like to do is:

You scroll through your work orders with the screen form and when you find the order you are looking for, you click a button for printing the order and then Access switch form to the printing form and sends it to the printer.

The problem I have:

I have made a button that marks the post that I am looking at in the screen form, and then prints the marked post. This works without any problem.
The problem is that when I add a step where I change the form, Access drops the marking and prints out all work orders.

I hope you understand what I mean, and have an easy solution for me.

Thanks for your help

/Niclas

[Bob Fitz]

Use a report for the printout. Use the same data source that you use for the form. Use the button on the form to send the report to the printer.

[Niclas]

Hi Bob

Thanks for your answer, but I still seems to get all posts in the report and not just the one I want to print.
Is there a way of limiting the report to only the post I am looking at with my screen form?

[Bob Fitz]

Try:
Docmd.OpenReport "[YourReportName]",acViewNormal, , "[NameOfIDFieldInTable] = " & Me.NameOfIDControlOnForm

Replace the names in BOLD with your actual names.