parameter query results not expected with lookup field 1

[weigoldk]

I have a table with a field that is populated by a lookup (created with the lookup wizard). The field is a text type with about 6 different options for the user to choose from. It works great to make sure the input is consistant and does not go outside the range of acceptable options.

I want to use that field for a paramter query. I want the user to be prompted for the field and have the results of the query to find all matching records. When I run the query, I am prompted, but when I type in a known value, I get an error: This expressiion is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements..."

What am I doing wrong? Is there a better way to accomplish what I need.

Thanks in advance for your help.

 

[PHV]

Have a look here:

http://www.mvps.org/access/lookupfields.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[weigoldk]

Thanks PVH,

LOL the article you pointed me to has the title, "The Evils of Lookup Fields in Tables". I am convinced! I will stay away from the Lookup Wizard and Lookup Fields.

Does anyone else have a direction to point me.

For input, I want to easily limit my end users to say 8 options. I then want my end users to run a report and to be prompted as to which value they would like to see in the report.

FieldA--limit input (drop down box would be nice)to
Apples
Bananas
Oranges
Kiwi
Pears
Grapes
Cantelope

ReportA
When it is run, the end user is prompted "What kind of fruit are you requesting". They then can choose from (again, a drop down box would be nice) the seven kinds of fruit listed above.

Is this possible, or am I fruity .

 

[PHV]

Play with a Lookup Table which primary key is referenced as foreign key in your main table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Bob44TheCat]

Hi,

You could also have a look at

http://www.fontstuff.com/access/acctut08.htm

Hope this helps,

Bob.

 

[weigoldk]

Bob44thecat,

That looks great! I'm at my "day-job" right now. I can't wait to get home and get to work.

Thanks!