Date query not working

[JimO]

I have a table of race results (Indy 500) and I want to be able to select a race date from a dropdown list and display the results from that race.

I have form set up with a query that works if I go into the query and enter the proper date such as #5/29/2016#.

When I set the query up from the form [Forms]![ResultsByYearF]![RaceYearCmb I get an error that it is typed incorrectly or is too complicated.



I have not been able to get this to work. I just need to select a single date not a range.

Jim O

[ranman256]

you missed the last bracket
[Forms]![ResultsByYearF]![RaceYearCmb]

[JimO]

Thanks for your response but, I am still getting the same error message. This expression is typed incorrectly or it is too complex to be evaluated.

Jim O

[Micron]

Maybe your year combo row source returns text and not a date? Create (if you don't have it already) an AfterUpdate event on the combo and use this:

If IsDate(Me.RaceYearCmb) then
  msgbox "Is a date"
Else msgbox "Is not a date"
End If

[JimO]

Ok now I get the message Is not a date. How do I fix that?

Jim O

[JimO]

It seems to be working now. Thanks to both of you for your time and effort.

Thanks
Jim O

[Micron]

I've had that error before - usually the cause was forgetting to wrap my dates in #'s but this was because I was concatenating a sql statement in vba. I don't get the impression you were doing that, and the test tells me your combo value is text that looks like a date rather than an actual date data type. What I posted is not a fix, so do not rely on it as it was only intended to tell me if it was a date or not. It makes no sense that it is working now by doing just that. You must have made some other changes?