Running Parameter Requires Table ID# Not Field Name

[gabrielnerf]

When I try to set a parameter for my inquiry, Access is looking for the table ID# instead of the text in the field I'm looking for.

eg:

Table- Inspection Results

ID Inspection Results
1 Pass
2 Fail
3 Non-rated

When I run a parameter inquiry requirement to look for inspection results, and I type the word "Pass" in, I receive an error. But, when I type "1" in, I get the information I'm looking for (all records with inspection results that were a "Pass"). Why is Access looking for the table ID number instead of the text value?

Could it be because the ID# is set as the Primary Key?



Any help would be greatly appreciated!

[June7]

Because you are doing a search on a field that has the ID value, not the descriptive Results.

Do you have Lookup set for the ID field in table that is being searched? This Lookup does not change the value in the field, even if you see the descriptive alias, the actual value is still the ID.

[gabrielnerf]

Yes it is a lookup in the table...if I change the field, will it mess up my relationships and other data?

[June7]

Change the field how? Why should you? The search on the ID is just as effective as the search for a word.

If you change the PK to the descriptive field, you will have change the foreign key data in all the related records.