Filter by table *resolved*
I have 2 tables, tblIssues and tblTypes
I want to filter the recordset a couple times by each record in tblTypes. For example,
tblIssues has 4 columns,
ID, p_id, summary and type_id
tblTypes has 2 columns
type_id, type
tblTypes looks something like
1 Dates
2 Modifications
3 Request
4 Telemarketing
each issue would be one of these types. I want to display all the issues in 4 separate tables, one for each type.
Currently my recordset contains all the records. I know i can filter using the rs.Filter, but how can i loop it so that it filters and displays by each type in tblTypes?
i know this sounds kind of confusing but I don't know how to explain it better.
thanks.