filtering a continuous form with two option groups

[bluesage]

hi,

i need an example code. what i have is a continous form with data containing an Id in one field, a month (ie.jan) in another field and the rest. i want to create two option groups, one to filter by month, then the second to filter by id.

i have done it with just one filter. ie. filter by month, but for each month there are numerous people (each id). so what i want is that once we have filtered by month, we can then filter by id so limit our list to one person in particular.

dont know how to do that. i need an example. is it possible to have a select case within a select case?. like this for example:

select case blabbla
case 1
filterstrSQL = strSQL & "Where ...."
and select case (this would be 2nd option group)
case 1 ....

if it is can you show me an example of how to code it?

thanks

 

[willir]

bluesage

The following post addresses this type of issue.

http://www.tek-tips.com/viewthread.cfm?SQID=839845&SPID=705&newpid=705&page=1

Richard