Form Filter Problem

[Larry8696]

I need to only show records that have been created today whenever the form is opened. The problem I have is that when
the form is closed and re opened, the filter does not work, I have to reset the filter.

 

[TheAceMan1]

How are ya Larry8696 . . .

In design view set the [blue]Filter[/blue] property. Then in the forms Load event add [blue]Me.FilterOn = True[/blue].
[purple]or[/purple]
In the [blue]Load event[/blue] of the form set the [blue]Filter[/blue] property and [blue]Me.FilterOn = True[/blue].
[purple]or[/purple]
If the forms [blue]Recordsource[/blue] is a query or SQL, set criteria for today: [blue]WHERE ([DateField] = Date())[/blue].

[blue]Your thoughts? . . .[/blue]

See Ya! . . . . . .

 

[Larry8696]

Now I know, works great, thanks