Requery on a date

Cissie Johnson · Nov 26, 2003

H
I'd like to filter and re-query based on date control I have on my form. Can anyone please advise me?

alan · Nov 26, 2003

-----Original Message-----
Hi
I'd like to filter and re-query based on date control I

have on my form. Can anyone please advise me?

.

Try this code in the On Click event of a command button.

Me.FilterOn = False

Me.Filter = "[Date Field] = #" & Me![txtDate] & "#"
Me.FilterOn = True