Find Record On Open

[TClark14]

I have a form based on a table. The primary field in the table is the date. I am trying to get the form, on open, to go to todays date. Would that be Date() ? I have tried putting this in the where property of the macros that opens the form. I have also tried adding a Find record line in the macro and using Date(), and have also tried Now(). Can anyone help me with this? My date is set up as a long date since I need to see the day of the week when the date is displayed.

Thanks
Terry

 

[saintsman]

Try:
=DateValue(Now())

 

[Pat Hartman]

The Where clause of the OpenForm method is the easiest way to do this. Did you perhaps leave out the field name that you need to compare to?

"YourDate = " & Date()

 

[TClark14]

I can get this to work, however, it is filtering the records and I do not want them filtered, I still want to be able to use the record navigator at the bottom to go forward or backward and filtering only shows todays date. I would like for the form to just GOTO todays date (as a starting point) and still allow me to scroll through earlier or later dates. Is this possible?

Thanks
Terry