Form Filters

[Transentient]

This maybe a simple issue.

I have a form which displays Company Names, persons to contact etc. I have succesfully created a series of filters activated from command buttons to filterthe form display dynamically based on salesman, a single level filter.

I now want to have a multi level filter, so i could filter on salesman, then machine types linked to the salesman.

I have used the following code to achieve the first level filter

Dim dbs As Database
Dim rst As Recordset                                                                    '
Dim strSQL As String

Set dbs = CurrentDb()
strSQL = "SELECT * FROM mailing_Transfer_Table WHERE [Salesman1] = 'Salesman name'"   'Define Filter
Set rst = dbs.OpenRecordset(strSQL)

Me!MailingList.Form.RecordSource = strSQL

Obviously there would be a name in the "Salesman name" field in the code.

My thoughts would be a second filter on the created recordset, am I on the right track? and how can I force the code to recognise when it needs to run the 1st level filter or the multi level filter.

Any ideas would be very greatfully recieved

Thanx in advance

 

[neileg]

I think you should look at cascading combo boxes. Do a search in these forums.