Open form to particular record based on date 1

[stc]

Hi,

I have a database where the date on which a particular event has to happen is recorded. The form displays each record individually and shows when the event has to happen and what has to happen. Currently the database opens at record #1. I would like to change it so that it opens to any events that have to occur today, or, if there are none taking place today, to the next event to take place. I have tried using a Find Record macro, but this doesn't seem to work. Can anyone point me in the right direction?

Thanks for any help...

 

[jdegeorge]

Set your form to a query where the criteria for this date field is

>=DATE()

with the sort as ASCENDING.

This will show only those records from today and later.

Hope this helps.

Jim "Get it right the first time, that's the main thing..."

 

[stc]

Thanks for this advice. Simple and effective!

 

[jdegeorge]

Any time, STC. Glad I could help.

Jim "Get it right the first time, that's the main thing..."