Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Form Filter Problem

Status
Not open for further replies.

Larry8696

Technical User
Joined
Dec 28, 2006
Messages
9
Location
US
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.
 
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]

Calvin.gif
See Ya! . . . . . .
 
Now I know, works great, thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top