Refine query based on option buttons

[GLT]

Hi,

I have a main form and a sub form (they are NOT linked).

However, on the main form I have 4 buttons which I would like to use as a
filtering for the sub form (sub form data comes from its own query).

So, when I select option 1, the sub form displays only windows servers, and
when i select option 2, the sub form displays only UNIX servers and if I
select button 1 and 2 then windows and UNIX servers are displayed.

Can anyone advise how I can program the main form to the query which the sub
form runs from?

Help is always greatly appreciated...

Thanks
GLT

 

[Duane Hookom]

I would use a multi-select list box of server types. Then use code to loop
through the selected items of the list box to create a filter. There is a
generic list box function you could use at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[GLT]

Thanks exactly what i wanted.

Cheers.

I would use a multi-select list box of server types. Then use code to loop
through the selected items of the list box to create a filter. There is a
generic list box function you could use at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.