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

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

Try replacing with this:

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

or

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

or

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

My guess is one of these will work...but of course, let me know!

Reply With Quote