Database dropdown resets on submit

B

Bill Bailey

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top