send dropdowns to ACCESS as query criteria

[david]

Hi,
I have got an asp page with several dropdown boxes, each created with the
database result wizard.
I want to pass these dropdowns to a secdond asp page to be used in query
criteria.
But how may I get the DRW on the second asp page to accept the dropdown
inputs from the 1st page?
David

 

[Tom Gahagan]

wag.....

If you HAVE to use the DRW for the second page I guess you are going to have
to take the picks from the dropdowns and put the values in a lookup database
and then have the second page use that with the DRW. Again... just a guess
as to how you might try it with the DRW. Doing this, however, you are going
to have to clean out the table at the end of each use AND it sets up are
real problem with concurrency... ie... what if two people are doing the form
at the same time?????? If there is no chance of that... and you are sure of
that (?) this might be a solution.

Of course there is a much easier way but you would have to know some asp so
you could get the values from the first page and use them to do what you
need to do without having to use the DRW.

Best to you...
Tom Gahagan

 

[Kathleen Anderson [MVP - FrontPage]]

One of these may help:
How to filter a database query by using a drop-down list in FrontPage 2000
http://support.microsoft.com/kb/235554

How to filter a database query using two drop down lists....
http://www.spiderwebwoman.com/tutorials/doubledropdown.htm

How to create a "Pick List" page with a dropdown list and generate a detail
page
http://www.spiderwebwoman.com/tutorials/picklist_with_dropdown.htm

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx