Copy a value out of a form

[ojah]

I have a database to manage products sold in a store.

I have report that creates a customer invoice. This is driven by a "transaction number". The query that powers this uses "[]" as the criteria, allowing me to enter the "transaction number" to open the relevent data in the report.

However, I want to be able to print the report from a button in the form, relevent to the transaction that is currently on screen. This would presumably involve somehow copying the value of the "transaction number" into the report criteria?

My knowledge of macros and coding is low. Thanks

 

[John Big Booty]

In the criteria for transaction number put; Forms!FRM_Name!ControlName

 

[ojah]

In the criteria for transaction number put; Forms!FRM_Name!ControlName

Thanks!! Much appreciated