Open a form based on date off another form

[BorisGomel]

Hello everybody,
I am trying to open form Cap Nan Form based on date in text box off another form Upload Form and got no result. Second form ( Cap Nan Form) is opened but no shows no record.
The code vb I use the below:
Private Sub OpenForm_Click()
On Error GoTo Err_OpenForm_Click
Dim DocName As String
Dim Criteria As String
DocName = "Cap Nan Form"
Criteria = "[Date of Report]=" & "'" & Me![txtDate] & "'"


DoCmd.OpenForm DocName, , , Criteria
Exit_OpenForm_Click:


Exit Sub
Err_OpenForm_Click:
MSGBOX Err.Description
Resume Exit_OpenForm_Click
End Sub

Thnak you in advance for help,

The Best Regards,

BorisGomel

[pbaldy]

See if this helps:

BaldyWeb wherecondition

Note the date delimiter.