Non expert doing things that aren't that hard but are beyond me

[phillyon]

I'm sure this should be easy but cannot make it work.

I have a MS Access table containing consecutive dates and daily comments, which when opened in a form displays other info relating to that date.

simply put, fields are Date and Comment

I would like to have a menu button which opens the date form but opens it on the current date, displaying the relevant info for the date in question (or none if that is the case). The form works and I can navigate around the dates and it displays ok but I can't figure out how to make it automatically open on today's date.

I've tried:

stDocName = "DIARY_MAIN"
DoCmd.OpenForm stDocName, , , , , , "[DATES].[DATE]=" & date()

but it takes off the () and won't do it.

any ideas?

[phillyon]

please anybody?

[Rabbit]

I'm sure this should be easy but cannot make it work.

I have a MS Access table containing consecutive dates and daily comments, which when opened in a form displays other info relating to that date.

simply put, fields are Date and Comment

I would like to have a menu button which opens the date form but opens it on the current date, displaying the relevant info for the date in question (or none if that is the case). The form works and I can navigate around the dates and it displays ok but I can't figure out how to make it automatically open on today's date.

I've tried:

stDocName = "DIARY_MAIN"
DoCmd.OpenForm stDocName, , , , , , "[DATES].[DATE]=" & date()

but it takes off the () and won't do it.

any ideas?

First, don't name your fields/tables/controls after reserved words and functions in Access. They make things all screwy.

Second, date value are delineated by surrounding them with # #. As in #1/1/2005#

[phillyon]

thanks, still can't get it but have more ideas.

[Rabbit]

Oh, and also, your criteria is in the wrong place, it should be the fourth parameter.