D
DZ
The project manager want the user to select names using checkboxes.
Then run a report with those names as filter.
I was thinking of accomplishing this by using DAO to loop through the
records and a building a WHERE clause to tack onto a query with something
like the following
If ckFilter = -1 then
strWhere = strWhere & " Or Name = '" & rs(Name).Value & "'"
End if
I was just checking if anyone out there might use different method to
filter a report based on checked off items.
Thanks for any ideas
Then run a report with those names as filter.
I was thinking of accomplishing this by using DAO to loop through the
records and a building a WHERE clause to tack onto a query with something
like the following
If ckFilter = -1 then
strWhere = strWhere & " Or Name = '" & rs(Name).Value & "'"
End if
I was just checking if anyone out there might use different method to
filter a report based on checked off items.
Thanks for any ideas