When starting the program, how set fokus on current date? date()

[tosv1516]

Hi.
I have read a lot , but not found a solution to achieve the following:
In a db I wish to get to a post of the current day as now() or date() , if it exist.
If not exist a record holding today's date, I wish to create it, and then work with it ( set focus ).
The purpose is to have an autoexec that either show the current already started record for today,
or create a new one to work with, and avoid getting double posts in the db.

Is there a simple yet effective solution to this ??

Best regards....


Torgeir

[pbaldy]

You can test for a record with the current date using DCount()

DLookup Usage Samples

If a record is found, open your form to that record:

BaldyWeb wherecondition

If not, open the form in Data Entry mode and populate the date field:

Forms!FormName.DateFieldName = Date()