Data Access Page Development Questions

[Leo]

I am trying to design a Data Access Page to narrow down a 10,000 record
recordset based on two parameters: Bank Name and Bank State. This is supposed
to be a rush job, and I was trying to sidestep having our system
administrator add my request for PHP with an ODBC Access/ MS SQL driver into
their long queue

So I have two questions. A successful answer to one of the two parts would
help me immensely.

1. My original design was similar to a PHP or ASP page. I was going to
create a DAP page via the Wizard, and then unbind the Bank Name and Bank
State controls from the table fields. I would create a button, and run a
simple VBScript sub to return a filtered recordset based on the control
values. The recordset would be placed into a div on the DAP’s HTML.

The problem is that the sub returns errors, and removes the quotation marks
from my <Script type=â€text/vbscriptâ€> tags. I have even tried this as
language=â€vbscriptâ€, and the results are the same.

Is there any way to do this with an Access DAP?

2. This is my end-around move, which also failed: Build the DAP based on a
parameter query. The system prompts me for the missing values, but returns a
page based on the empty recordset. Is there any way to build a DAP based on a
parameter query?

Thanks,
Leo

 

[Ken Snell \(MVP\)]

Perhaps this sample database will give you some ideas:

DAP that filters subsequent DAP
http://www.accessmvp.com/KDSnell/SampleDBs.htm#FilterDAP