query parameters in db results wizard

[SAC]

I'm learning to use the db results wizard and have success in passing
parameters to a query from a filed on the same form.

How can I pass a parameter from a filed on a different form? I'd like to
have a drop down box, select an item and then open a new page displaying
results from the DB results wizard based on the selection of the drop down
box.

Thanks.

 

[Jim Buyens]

-----Original Message-----

I'm learning to use the db results wizard and have
success in passing parameters to a query from a filed on
the same form.

How can I pass a parameter from a filed on a different
form? I'd like to have a drop down box, select an item
and then open a new page displaying results from the DB
results wizard based on the selection of the drop down
box.

On this "different" form:
1. In Form Properties, select Send To Other.
2. Click the Options button.
3. In Action, specify the URL of the DRW page, such
as dbinfo.asp.
4. Click OK and OK.
5. Make sure the form field names on the first page and
the Criteria field names you specified on the second
page are in sync.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*========----------
|\=========------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/=========------------
*========----------

 

[SAC]

Excellent! Thanks!

On this "different" form:
1. In Form Properties, select Send To Other.
2. Click the Options button.
3. In Action, specify the URL of the DRW page, such
as dbinfo.asp.
4. Click OK and OK.
5. Make sure the form field names on the first page and
the Criteria field names you specified on the second
page are in sync.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*========----------
|\=========------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/=========------------
*========----------