Solved How do I compare date variable in combo box?

[hucheunghugo]

DoCmd.RunSQL "Update Houses SET Houses.DateCond = 1 WHERE (DateValue(Houses.Date) = #Combo347.value# );"
This is my code
But they keep showing me that there are runtime error 3075
I am getting frustrated by that

 

[The_Doc_Man]

Either of two ways:

DoCmd.RunSQL "Update Houses SET Houses.DateCond = 1 WHERE (DateValue(Houses.Date) =  Forms![" & Me.Name & "]!Combo347 );"

or

DoCmd.RunSQL "Update Houses SET Houses.DateCond = 1 WHERE (DateValue(Houses.Date) =  #" & Me.Combo347 & "# );"

It would depend on whether the bound column from the combo was a real date variable or a date string.

 

[hucheunghugo]

Sorry to disturb
I tried the second one, it shows that type mismatch, does it mean that i have to use the first one?
And do i have to change the Me.Name for the first way
Thanks!

Either of two ways:

DoCmd.RunSQL "Update Houses SET Houses.DateCond = 1 WHERE (DateValue(Houses.Date) =  Forms![" & Me.Name & "]!Combo347 );"

or

DoCmd.RunSQL "Update Houses SET Houses.DateCond = 1 WHERE (DateValue(Houses.Date) =  #" & Me.Combo347 & "# );"

It would depend on whether the bound column from the combo was a real date variable or a date string.

 

[hucheunghugo]

Either of two ways:

DoCmd.RunSQL "Update Houses SET Houses.DateCond = 1 WHERE (DateValue(Houses.Date) =  Forms![" & Me.Name & "]!Combo347 );"

or

DoCmd.RunSQL "Update Houses SET Houses.DateCond = 1 WHERE (DateValue(Houses.Date) =  #" & Me.Combo347 & "# );"

It would depend on whether the bound column from the combo was a real date variable or a date string.

Oh wait Its fixed thanks a lot