View Full Version : Code error


haavar
10-02-2007, 06:59 AM
I got errors when I try to use this code in the "Filter" with the report. Whats wrong?
[Feil_problem].[dato] BETWEEN [Forms]![Rapportering].[Text9] AND [Forms]![Rapportering].[Text11]

boblarson
10-02-2007, 07:06 AM
I'm assuming dato is a date (due to the Between...And) but if it isn't, please correct me.

You need to pass the filter a string but with the controls outside of the string:

"[Feil_problem].[dato] BETWEEN #" & [Forms]![Rapportering].[Text9] & "# AND #" & [Forms]![Rapportering].[Text11] & "#"

haavar
10-02-2007, 07:54 AM
Hey!
Thanks....