Parameters driving me mad

[reburton]

I have a number of queries that use parameters and they all prompt me multiple times for the same input, especially if I run them from a report. When I try to edit the reports the prompt keeps popping up asking me for a date. Is there any way to stop this?

[pbaldy]

I would have the user enter the parameter on a form, and have the queries get it from there.

[reburton]

Thanks for replying so quickly! I am sure that's a better way to do it, but I'm afraid I don't know enough SQL to pull it off.

[pbaldy]

You can right-click and use Build in the criteria, or replace the bracketed criteria:

[Enter whatever]

with a reference to the form:

Forms!FormName.TextboxName

[reburton]

Many thanks! That, I think I can handle. I'm rather green at this and I really appreciate your help.

[June7]

Annoying prompts is why I don't use dynamic parameterized queries. I use code to build filter criteria. Use the constructed filter to:

1. set Filter and FilterOn properties of form

2. set the WHERE CONDITION of OpenForm (or OpenReport)
DoCmd.OpenForm "form name", , , strCriteria

Review http://allenbrowne.com/ser-62code.html

[pbaldy]

Happy to help!

[reburton]

I know I'm getting to be a nuisance, but I am still having a hard time with the solution that pbaldy suggested. I used the expression builder like he suggested and Access put up a message stating that my values were not valid. I used: =[Forms]![EnterStartDateFrm]![txtStartDate] the only thing I added was the = sign. The rest was straight from the expression builder. I don't know very much about forums either, so I don't know if posting this after it is marked "Solved" will even get it seen.

[pbaldy]

In design view of a query you wouldn't want the =.

[reburton]

I thought of that before I posted, but when tried to delete it Access plugged it right back in. and then complained that the Field address was invalid. I know this must be something I'm doing wrong but I am stumped.

[pbaldy]

Can you post the SQL of the original query?

[reburton]

I am embarrassed to say I finally figured out how to accomplish what I needed to do. Part of my problem was an error in my logic. Another was an incorrect join.
I still don't have a handle on getting a value from a form, but I'm working on it; I really hate those parameters in the queries. Could you send me a segment of code to show me how it is done?
I really appreciate your spoon-feeding me like this. I am handicapped and only able to use two fingers to type so I do a lot of cutting and pasting. A snippet of cade really is helpful. Thanks again!

[pbaldy]

In design view it looks like this:

[June7]

I referenced in post 6 a link to article that shows VBA alternative.

[reburton]

Thanks a million! I'll give this a whirl later on this evening.