Dialog and prompt forms in Access

[dunkleypilot]

Greetings,

I am relatively new to access and am pretty much learning as I go. What I am trying to do is to use the acDialog feature to provide information to a query that generates a report. I have built a Dialog form to provide the information. I am just not sure how to code the report, and or query to use it and then generate my report.
Thanks for the help,
Steve

[PEB]

Hi Steve,

Use parameter values for your needs! Imagine you have a query and you want to introduce on it your salary as criteria!

So as criteria in your query type [Enter your salary]

:)

[dunkleypilot]

How would I generate a report that calls on several queries with date ranges. If I use parameter values then I would have to enter the date range about 5 times. I explored trying to do the whole report with one query but I don't think it will work. Thanks for the help.

[PEB]

Hi,

Use the same parameter names...

:)

[dunkleypilot]

Hi,

Could you explain that a little more....

Thanks,

Steve :)

[PEB]

Hi,

For exemple in one of your queries you want to introduce a parameter Name

So as criteria you type:
[Name]

In other query you need the same parameter

so in the criteria of the respective Query you type also:
[Name]

When you join the queries there is only 1 parameter that is named [Name]
to introduce

Is this enought?

:)