another question from the newbie,

Is it possible to filter a recordset based off of a selection made from a 
combo/list box? if so, how?

Thanks again,

JB

Yes, it is possible...

3 ways I know of...

1st way:
Place the combo on the left frame and on the onchange event submit the
form to the frame on the right, using the combo value to filter your SQL
string.

2nd way:
Post the form to the same page it's on. Use the combo value to filter
your SQL string. You have to use some sorte of if then else statement so
you won't have an error the first time the page loads.

3rd way:
Use javascript to build the array of the selection you want to filter...
afatic I can't help you much, because I'm not very into javascript....

HTH

PauloF




-----Original Message-----
From: Jerry Brown [mailto:jbrown@b...] 
Sent: sexta-feira, 21 de Fevereiro de 2003 16:38
To: Access ASP
Subject: [access_asp] filtering recordsets

another question from the newbie,

Is it possible to filter a recordset based off of a selection made from
a 
combo/list box? if so, how?

Thanks again,

JB