type mismatch

[camidon]

When I use this line of code:

DoCmd.OpenReport stDocName, acPreview, , "GroupName = Forms![frmTAbyGR]![txtGroupName]" And "[OpenDate] Between #" & Format(BeginDate, "mm\/dd\/yyyy&quot & "# And #" & Format(EndDate, "mm\/dd\/yyyy&quot & "#"

I get a type mismatch error. Any idea as to why I would be getting this error and something I can try to make it work correctly.

I'm delaring both variables as strings.

Thanks for the help!

camidon

 

[JoeMiller]

You need to declare your variables as dates if you want them to match a date/time datatype (OpenDate).

HTH Joe Miller
joe.miller@flotech.net