J
Jaybird
I feel stupid for resorting to this but here goes... I can't figure out
what's wrong with my form based parameter query. It won't accept the
criteria entered into the form. I've got a form called frmPricingCriteria
and an unbound textbox called txtCompanyName. Also on the form is a command
button which runs the query. The criteria for the CompanyName field on the
query is [forms]![frmPricingCriteria]![txtCompanyName].
For giggles, here's the SQL: SELECT Contacts.CompanyName, [Order
Entry].[Part Number1], [Order Entry].[Start Temper], [Order Entry].[Finish
Temper], [Order Entry].Alloy, ProcessCodes.[Process Key]
FROM (Contacts INNER JOIN [Order Entry] ON Contacts.ContactID = [Order
Entry].ContactID) INNER JOIN ProcessCodes ON [Order Entry].[ID Process Key] =
ProcessCodes.[ID Process Key]
WHERE (((Contacts.CompanyName) Like NZ("*" &
[forms]![frmPricingCriteria]![txtCompanyName] & "*")))
ORDER BY Contacts.CompanyName, [Order Entry].[Part Number1];
Whenever I run my query using the criteria from the form, it returns no
records. If I enter parameters directly without the form, it works. So, I
don't believe the problem is with my query. I believe the syntax for the
criteria is correct to read the values from my form. I've checked and double
checked the spelling of the names for both the form and the textbox.
Everything appears to be right. What am I missing? BTW, the data I'm using
as my sort criteria is valid as well. Please tell me its something I didn't
know and not something easy that I overlooked!
what's wrong with my form based parameter query. It won't accept the
criteria entered into the form. I've got a form called frmPricingCriteria
and an unbound textbox called txtCompanyName. Also on the form is a command
button which runs the query. The criteria for the CompanyName field on the
query is [forms]![frmPricingCriteria]![txtCompanyName].
For giggles, here's the SQL: SELECT Contacts.CompanyName, [Order
Entry].[Part Number1], [Order Entry].[Start Temper], [Order Entry].[Finish
Temper], [Order Entry].Alloy, ProcessCodes.[Process Key]
FROM (Contacts INNER JOIN [Order Entry] ON Contacts.ContactID = [Order
Entry].ContactID) INNER JOIN ProcessCodes ON [Order Entry].[ID Process Key] =
ProcessCodes.[ID Process Key]
WHERE (((Contacts.CompanyName) Like NZ("*" &
[forms]![frmPricingCriteria]![txtCompanyName] & "*")))
ORDER BY Contacts.CompanyName, [Order Entry].[Part Number1];
Whenever I run my query using the criteria from the form, it returns no
records. If I enter parameters directly without the form, it works. So, I
don't believe the problem is with my query. I believe the syntax for the
criteria is correct to read the values from my form. I've checked and double
checked the spelling of the names for both the form and the textbox.
Everything appears to be right. What am I missing? BTW, the data I'm using
as my sort criteria is valid as well. Please tell me its something I didn't
know and not something easy that I overlooked!