View Single Post
  #2 (permalink)  
Old June 28th, 2005, 09:02 AM
Developer1861 Developer1861 is offline
Authorized User
Join Date: Jun 2005
Location: , , .
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts

Ok, here is your sql string:

strSQL = "SELECT * FROM qryEnablerLookup WHERE [fkMonthID]" & " = '" & Forms!frmCriteria!cboMonth & "';"

1. Make sure that the field "fkMonthID" actually exists in your query and is spelled correctly.

2. Make sure your query is spelled "qryEnablerLookup"

3. do a debug.print or a msgbox(strSQL) or add a watch to see exactly how this string looks. If fkMonthID is a numeric field, then the single quote surrounding the expected value will give you another error after the "too few parameters" error is solved. (Data type mismatch)

These steps should solve your problem. Most likely you have misspelled the field name.

Reply With Quote