Troubles with date variable

[rod4]

hello guys,

my goal is to open with doubleclick a record in a datasheet a form where i can see the records full page with more informations. so i dblclick on the field IDate and the form opens with the correct date and according informations in the record of this date.

the modul looks as follows:

Private Sub Info_DblClick (Cancel as Integer)

    DoCmd.OpenForm "InfoForm" ,,, "[IDdate] =" & [IDdate]

End Sub

my problem is, the form is always empty.

when i use the [infoID] instead of [IDate], then i get the correct record to the field [infoID]. but i want to use the IDate.

what do i do wrong?

[Seth Schrock]

Date values need hashtags surrounding them. So your WhereCondition clause needs to be

"[IDdate] = #" & [IDdate] & "#"

[rod4]

thanks a lot! i had this idea already too, but with the wrong syntax! :)

[NeoPa]

Please check your questions carefully before posting. In various different parts of the thread you have referred to [IDate] & [IDdate]. It's very hard to work with unreliable information.

[rod4]

Sorry won't happen again!

[NeoPa]

: - )