Showing current date

  • Thread starter Thread starter Steve G
  • Start date Start date
S

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!
 
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,
 
Back
Top