M
Mannie G
I am using a pop-up form to allow filtering of data in a report. I have
copied the code from support article 208529 :-
If Me("Filter" & intCounter) <> "" Then
strSQL = strSQL & "[" & Me("Filter" & intCounter).Tag & "] " & " =
" & Chr(34) & Me("Filter" & intCounter) & Chr(34) & " And "
I have a problem with the code below because of mixed data types. I have
one text field, one date field and 3 YES/NO checkbox fields. If I use the
code as it is it worls with the text field. if I remove the & Chr(34) it
works OK with the 3 Yes/No fields.
The date field is also causing a problem with or without the Chr(34). In
the Combo box for that field I want to be able to filter the records by 'Is
Not Null' or Is Null' I cant seem to get this to work with or without the
Chr (34) code.
Can anyone suggest a fix to allow the form and code to work with the mixed
data.
Any help would be appreciated.
copied the code from support article 208529 :-
If Me("Filter" & intCounter) <> "" Then
strSQL = strSQL & "[" & Me("Filter" & intCounter).Tag & "] " & " =
" & Chr(34) & Me("Filter" & intCounter) & Chr(34) & " And "
I have a problem with the code below because of mixed data types. I have
one text field, one date field and 3 YES/NO checkbox fields. If I use the
code as it is it worls with the text field. if I remove the & Chr(34) it
works OK with the 3 Yes/No fields.
The date field is also causing a problem with or without the Chr(34). In
the Combo box for that field I want to be able to filter the records by 'Is
Not Null' or Is Null' I cant seem to get this to work with or without the
Chr (34) code.
Can anyone suggest a fix to allow the form and code to work with the mixed
data.
Any help would be appreciated.