Bill Bailey
4/4/2004 9:31:00 PM
I used the Database Results Wizard (DRW) in FP 2002 to
build a page that queries a database. I placed a dropdown
listbox on the page to filter the display of database
results on a page. The dropdown is itself built by the
DRW from another table in the database. This technique
works great with one minor (and annoying) problem: the
dropdown always resets itself after I click the "Submit"
button in the search form. Thus the user cannot look at
the dropdown to determine the filter setting that was used
to generate the page. How can I retain the dropdown
setting after the user clicks the "Submit" button?
Because the dropdown is populated by a database table, its
not as simple as embedding an expression inside the
<option> tags that define the list.
Thanks in advance for any help.