matching date Values

[George]

Good Day all,

by pressing a button on a form, I want to load a mainform with its subform given the following statement:

doCmd.OpenForm "frmSigninSupervisor", acNormal, , "DateValue(tblSignin.[DateCreated])=# " & Me.Text56 & "#"

but an error message pops up as follow: Data type mismatched in criteria expression.


However pressing another button on another form in a similar situation works fine. Here is the code:

DoCmd.OpenReport "tblsignin", acViewReport, , "Datevalue([Auto Date]) =# " & Me.Text6 & "#"

These codes looks similar so I would be very grateful if anyone can explain the reason for the error message and show how to overcome.

[ranman256]

you have spaces next to the # sign, remove it.
(dates also work as text with a quote sign)

[George]

Thank you.

Also the bound Column had to be set to 2