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

then it isnt neccessary to even have:

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

all you need is

strSQL = "SELECT * FROM qryEnablerLookup;"

since [fkMonthID] is already selected for in qryEnablerLookup. So if your code works with the above assignment to strSQL instead of your old one, then you should be fine. Again, let me know.


Reply With Quote