Filter between two dates from unbound fields .... Wrong code...

[charly.csh]

Hello everyone

I'm trying to filter a database between two dates in a form, the issue I have is that the fields originally were textboxes (unbound) with 'input mask' as :00/00/0000;0;_

And of course in the format of those were added 'Short Date'

The field originally to be filtered was called 'Date' from table (I know MS Access has that name reserved for itself) for that reason I changed the name in the form to Datetxt in the properties

With my code I inserted....

Private Sub Filtercmd_Click()

Me.Requery
Me.Filter = "Datetxt >= "& "#" & StartDatetxt & "#" And "Datetxt <="& "#" & EndDatetxt & "#"


Me.FilterOn = True

End Sub

It shows an error, what could be wrong?

[John_G]

You have the syntax of the filter statement wrong - the "And" must be in quotes as well. Try this:

Me.Filter = "Datetxt >= #" & StartDatetxt & "# And Datetxt <= #" & EndDatetxt & "#"

John

[charly.csh]

It changed that to your code and it shows an input box asking me ENTER PARAMETER VALUE "Datetxt"

Do you know why?

[John_G]

It is probably because there is no field called "Datetxt" in the table or query that is the recordsource for the form. The filter must refer to the RecordSource field names, not the names of the form Controls. If you (correctly) don't want to use "Date" as a field name, you have to change it in the table as well as on the form.

[charly.csh]

You were right that was the problem!!!
thank you very much!!!