Filter Issues using a form command button

[snoopy92211]

Howdy folks! I tried to search on this one, but it didn't find any applicable info.

I have a form with several controls that serve as filter. I managed to fix all of my filter buttons with the exception of this one.

I have 2 calendar controls ...I'm trying to filter the data on a date range.

(how my form works: I have the controls to, from, color, size. At the top of my form, I have these same forms, but with a filter button next to them. The usr selects whatver criteria and the form filters with the data from the table.)

Here's my code and explanation behind the filter control.

me. references my form; the filters are named to and from, respectively. i'm actually trying to filter on the date field in my name table. I

'm geting this error:
Run-Time error 2448: I can't assign a value to this object.

Me.Filter = "Date = Between " & Me.from & " and " & Me.to & ""
Me.FilterOn = True
Form.Refresh

Any tips would be greatly appreciated.

Thanks!
snoopy

 

[Zion7]

Try...

Me.Filter = "Date Between #" & Me.from & "# and #" & Me.to & "#"

Be careful of using VBA reserved words for control names. (Date), I'd use txtDate or DateStarted or InvoiceDate...


Either way, Good Luck!