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:
Expand|Select|Wrap|Line Numbers
- Private Sub Info_DblClick (Cancel as Integer)
- DoCmd.OpenForm "InfoForm" ,,, "[IDdate] =" & [IDdate]
- End Sub
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?