Hello,
I have one ComboBox, cboSnapshotDt, that allows the user to select a date value. I have a second ComboBox that populates from a query that uses the value from the first ComboBox (see code below). My problem is that I get zero returns from this query and I think that there is some issue with how the date value is being formatted. The query works to populate the second ComboBox if I remove the date condition, but only if I delete the second ComboBox and recreate it (it works initially without the date, but if I try to add the date parameter it doesnt work anymore even if I undo the query change).
Is there some way to see what the query looks like when it runs, some kind of debug feature? Or is there something obvious that I am missing with including this variable in my work?
Code:
Me.cboForecastGrp.RowSource = "SELECT DISTINCT DEF_SKILLS.FORECAST_GROUP FROM DEF_SKILLS " & _
" WHERE DEF_SKILLS.SNAPSHOT_DATE = " & Nz(Me.cboSnapshotDt) & _
" ORDER BY DEF_SKILLS.FORECAST_GROUP DESC"