Running a query from a table that is using a field with a lookup wizard...

[renegp55]

I am trying to run a query based on a table where I used the lookup wizard to get data from another table. I want to ceate a query using text, e.g. [Enter CrsCode:] CU0DIV. Seems I can not run the query because I am using text and the lookup field is using the number ID in the lookup table...any ideas on how to fix this...

[June7]

What do you mean by 'create a query using text'?

Show the query SQL statement.

[renegp55]

[QUOTE=June7;162758]What do you mean by 'create a query using text'?

In the query view in the criteria box I entered : [Enter CrsCode:] and then run the query. When it asks for a CrsCode I entered one of my course codes for ex. CU0DIV and then run the query. Get error msg, I think problem is I used the Lookup wizard when creating the table I am using to run the query on. Found out later that this was a no-no but, kind of late now. I think the query is trying to run but is looking for a num value instead of text I typed..
D

[June7]

Yes, if the field is a lookup then the actual value of the field is the number ID, not the alias text descriptor.

I never use query parameter input prompts. Can't validate the input and as you have discovered, no good with lookups. Use a form for users to input/select criteria.

Review:

http://datapigtechnologies.com/flash...tomfilter.html