I don't care for parameter prompts. Consider adding a text box (or maybe a
combo box) on a form to use for the criteria. Then your SQL might look like:
SELECT MyTable.Tag1, MyTable.Tag2
FROM MyTable
WHERE MyTable.Tag1 = Forms!frmMyCriteria!cboTag1;
--
Duane Hookom
Microsoft Access MVP
NOTE: These public News Groups are ending June 1st. Consider asking
questions at
http://social.answers.microsoft.com/...ddbuz/threads?
"Paul Kraemer" wrote:
Hi,
I am using Access 2007. I have created a report where the RecordSource is
set to something like the following:
SELECT MyTable.Tag1, MyTable.Tag2 FROM MyTable WHERE MyTable.Tag1 = 999;
The WHERE clause is hard coded so that it only looks for records where Tag1
= 999. Rather than having this hard-coded, I would like to make use of a
parameter so that when I run the report, it will ask me to enter the Tag1
value I want to use for filtering the report.
If anyone can tell me how to do this or point me towards something I can
read that would be helpful, I'd really appreciate it.
Thanks in advance,
Paul
--
Paul Kraemer