VBA on split form for start and end date filter

[data808]

Can anyone please help me create a VBA to do a start and end date filter?



The idea I had was to create two unbound text boxes. One for the start date and the other for the end date. Then also have a filter button and an undo filter button.

Can this be done? I know nothing of VBA so there's no real point in trying to give me hints to write the code because I really can't do it. Sorry.

Thanks for the help.

[June7]

Techniques referenced on other thread can be used https://www.accessforums.net/forms/v...ing-41238.html

Doesn't matter which method you use, some code will be required.

If you don't want to use Allen Brown's coded approach, the alternative is a dynamic parameterized query, example also already referenced.

However, data ranges are a bit more complicated. Try something like:

SELECT * FROM tablename WHERE initials LIKE "*" & Forms!formname!txtInitials & "*" AND [Permit Number] LIKE "*" & Forms!formname!txtPermit & "*" AND [date field] BETWEEN Nz(Forms!formname!txtStart,1/1/1900) AND Nz(Forms!formname!txtEnd,12/31/2900);