Filter from a combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

OK, I give up.

I have a combo box that is listing weekending dates off of a query that is
grouped by dates. I have a table of records that I want to filter by the
results of the combo box. When I use the current code it tells me that I have
a data type mismatch or a size issue in my field. Any help is appreciated.

JC
 
Joe said:
OK, I give up.

I have a combo box that is listing weekending dates off of a query
that is grouped by dates. I have a table of records that I want to
filter by the results of the combo box. When I use the current code
it tells me that I have a data type mismatch or a size issue in my
field. Any help is appreciated.

JC
Click to expand...

Most likely the "dates" coming from the query are actually text that look like
dates. Try wrapping CDate() around whatever expression is producing them.
 
Does the Bound Column of the combo box contain the actual value that you
want to use in the filter?

Are the data types of the Bound Column field and the filtered field the
same?

Often, the columns in the combo box's Row Source query that are not the
Bound Column will be converted to "text" even if they started as date or
number. So if you're using one of these columns in your filter, you may need
to recast the value as the proper data type.

If you need/want more specific information / suggestions, you'll need to
give us a lot more details about what you're doing and what your setup is.
 
Back
Top