Problem Populating ComboBox with Query Keyed off of other ComboBox

[raynman1972]

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?

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"

[rzw0wr]

Try putting # signs around your date.
WHERE DEF_SKILLS.SNAPSHOT_DATE =" & "#" & cboSnapshotDt & "#"

Dale

[raynman1972]

That worked like a charm, thanks! One additional, is there syntax I should use when doing the same thing but with a string value?

[rzw0wr]

Yes. Numbers do not need any quotes.

"WHERE Number =" & number
Variable or not.

"Where Text ='" & Text & "'"

If text is not a variable then,
"Where Text = 'Text'"

I think I have these correct.

I am not very good with SQL stuff yet.


Dale