Defineing Variables To Fill a Report/DYNAMIC REPORTING

The goal here is to design a database where once an Invoice is opened a focus is set on the Invoice number.

I want to then apply this invoice number to a report so I do not have to requery the end user to re-enter the same Invoice Number.

I need help defining variables for my KEY ID: INVOICE, and then help writing code to use this variable as the default value to run the report with.

I can share the project if it helps but do not know how to start defining this.

Seems like this should be easy but do not know which commands are approperate.

re: Defineing Variables To Fill a Report/DYNAMIC REPORTING

1. To set the focus to the invoice number you have to set his Tab order property to 0
2. To use your invoice number in your report you can do it by using a recordset behind your report
or
yo can gat your variables from the form where is your invoice!

Obviously you want to get the variables from the Form

You can do it setting the property of a field of your report = Forms![My_invoice]![My invoice number]

:)