Requery on a date

[Cissie Johnson]

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

 

[alan]

-----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