Using expressions and current ID of a form to create a query and print a report.

[Kevin.Murad]

Hello all,
I am new to this forum as well as Access as a whole. I do have some knowledge and have created macros and expressions to automate functions in my database but I do need some help.

I want to have Access run a query, open a report, and print the report based on the ID number of the form that I have open. Is this possible?

The situation would be, I have a form that uses the the primary key as a record number. After I enter the data into the form, with the form open I want to add a button to open and print a report of the current record number.

Thanks in advance

[NTC]

Yes this is routine. first - when you open a report it defacto runs its record source query (if it's record source is a query...) so you don't need to explicitly fire the query.

There are 2 approaches:
Query: in the query that is the record source of the report - "call" the ID value from the form by putting it in the criteria of the query. the syntax is: Forms!FormName.ControlName

Opening Argument: look into the Opening Argument - if you are using Macros vs VBA will differ - but the concept is the same: and in the 'Where' section of the Opening Argument you enter the form's control name that holds the id.

Hope this helps

[Kevin.Murad]

NTC,

Thank you for the response, I tried the code but I must be missing something. When I run the query a window comes up wanting me to enter the record (ID) number that I want pulled up.

[NTC]

that means that your criteria in the query cannot be found. it could be a typo or a misunderstanding.... presuming you are using: Forms!FormName.ControlName

then double check that you have the correct names.....