Filter between 2 data

[Akchayan]

Hello all,




I have a form that is connected to a table. I have the column "Invoice date" there.
In the form I have this input:

txt1 is the first date
txt2 is the second date


The filter should be between txt1 and txt2. So it should be filtered in the column "Invoice date".


It should be filtered as soon as I click on the "filtern" button.


How do I do that?

[Welshgasman]

Lookup setting a filter on a form.
Basically, define the filter, then set filter=on

[ranman256]

me.filter = "[fieldname] between '" & me.txt1 & "' and '" & txt2 & "'"
me.filterON = true

[Gicu]

A small tweak to ranman's suggestion as you mention your filtering on a date field:

Me.Filter = "[fieldname] between #" & me.txt1 & "# and #" & txt2 & "#"
Me.FilterOn = True

Cheers,

[Akchayan]

A small tweak to ranman's suggestion as you mention your filtering on a date field:

Me.Filter = "[fieldname] between #" & me.txt1 & "# and #" & txt2 & "#"
Me.FilterOn = True

Cheers,

I copied the code but i get a error at "Me.FilterOn = True" :

The error code says:
Runtime error 3076


Syntax error in date in criteria expression.

[Welshgasman]

Debug.print Me.filter and post back here.

Do yourself a favour, give your controls some meaningful names , textxx is not going to mean anything to anyone in a few months.

[Micron]

There is no guarantee that the date is date data type?
@Akchayan, are the dates left or right justified in your table, or can you say with certainty what data type they are by looking at table design if need be?