FrontPage 2000 PullDown positioning or Db filter.

[CommanderTed]

I have a form with a databse fed PullDownBox. It loads data just fine.
select and use it to load data onto another page. Work fine.

My question is... I want to add a TextBox to the form and use it as
SEARCH filter, where, after its first display (default of "A"), wil
help position the PullDownBox to a specific entry.

Example: The PullDownBox has a complete list of all Employee Name
(Last, First). I open the PullDown and scroll through all 5000 entries
I click one and bring up the employees page. What I would like to do i
add a TextBox to the form (Find Employee) where the User may enter
partial argument (Smith, or Tayl, etc.), press Enter, and have thi
entry automatically position the PullDownBox to the Nearest entry.

I have tried creating the TextBox, giving it a default value of "A"
then using it in the SQL entry as a "LIKE". But wasn't able to get tha
to work.

I prefer staying with the "clickable" Frontpage options (and variabl
fill-ins) rather than resorting to custom html entries. BUT, I will i
I have to.

Any help would be appreciated

 

[Stefan B Rusynko]

Once the form is rendered by the browser you can't modify another form field from the DB (w/o preset javascripted client side code
which defeats the whole purpose of the DB)

Create the 1st page w/ a search (your like) and use your like results to populate a results page from the DB (w/ a dropdown form
field of just the results)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|
| I have a form with a databse fed PullDownBox. It loads data just fine. I
| select and use it to load data onto another page. Work fine.
|
| My question is... I want to add a TextBox to the form and use it as a
| SEARCH filter, where, after its first display (default of "A"), will
| help position the PullDownBox to a specific entry.
|
| Example: The PullDownBox has a complete list of all Employee Names
| (Last, First). I open the PullDown and scroll through all 5000 entries.
| I click one and bring up the employees page. What I would like to do is
| add a TextBox to the form (Find Employee) where the User may enter a
| partial argument (Smith, or Tayl, etc.), press Enter, and have this
| entry automatically position the PullDownBox to the Nearest entry.
|
| I have tried creating the TextBox, giving it a default value of "A",
| then using it in the SQL entry as a "LIKE". But wasn't able to get that
| to work.
|
| I prefer staying with the "clickable" Frontpage options (and variable
| fill-ins) rather than resorting to custom html entries. BUT, I will if
| I have to.
|
| Any help would be appreciated.
|
|
| --
| CommanderTed
| ------------------------------------------------------------------------
| CommanderTed's Profile: http://www.highdots.com/forums/m1577
| View this thread: http://www.highdots.com/forums/t3151728
|