waylander32
Registered User.
- Local time
- Today, 00:50
- Joined
- Oct 20, 2010
- Messages
- 20
HI
Confused below is some code I'm using to filter a report on opening.
Private Sub cmd_specfic_Click()
DoCmd.OpenReport "rpt_specfic_panel_time_detail", acViewReport, , _
"[house number]='" & Me.txt_h_no & "'" And _
"[project code]= '" & Me.txt_pc & "' " And _
"[panel ref]='" & Me.txt_p_ref & "'"
End Sub
if I do each one seperatly they work as soon as I join using "and" I get a type mismatch error
can some one please point me in the right direction
cheers
Confused below is some code I'm using to filter a report on opening.
Private Sub cmd_specfic_Click()
DoCmd.OpenReport "rpt_specfic_panel_time_detail", acViewReport, , _
"[house number]='" & Me.txt_h_no & "'" And _
"[project code]= '" & Me.txt_pc & "' " And _
"[panel ref]='" & Me.txt_p_ref & "'"
End Sub
if I do each one seperatly they work as soon as I join using "and" I get a type mismatch error
can some one please point me in the right direction
cheers