Showing current date

[Steve G]

Hi,

I am creating a form in Access 2K that displays a current
events calendar.

My question is how can I code my form to show the events
for the current day instead of starting at the first
record which is the first of the year? I don't want to see
what happened 10 months ago and have to scroll through all
the records to see what is going on today.

Any help will be great! Thanks!

 

[Cheryl Fischer]

You could make the Record Source of your form a query, as follows:

Select * from MyTable Where EventDate = Date()

or, to see events from the current date and forward:

Select * from MyTable Where EventDate >= Date() Order By EventDate


hth,