Type Mismatch Error

[waylander32]

Please help
no matter what I do I get a type mismatch error 13 with the code below.
If I try them seperatly they work
If I feed the filter directly into the report it works but as soon as i use the code below I get the error

The house number is a text field and the run date as the title surgests is a date field

your help will be appricated




DoCmd.OpenReport "rpt_panel_time_detail", acViewReport, , " [run date]=# " & Format(Me.txt_run_date2, "mm\/dd\/yyyy") & " # " And "[House Number]='" & Me.txt_house_number2 & "'"

 

[boblarson]

You have a quote or two out of place (it should be):

DoCmd.OpenReport "rpt_panel_time_detail", acViewReport, , "[run date]=# " & Format(Me.txt_run_date2, "mm\/dd\/yyyy") & " # And [House Number]='" & Me.txt_house_number2 & "'"

 

[waylander32]

Thanks fro the help
worrked a treat