I want the drop down box to react when a selection is made without using a submit button as shown below

<form method="get" action= "<%= strURL %>">
  <select name="col_name">
    <option>--Select Search--</option>
    <option>Livery</option>
    <option>Chassis</option>
    <option>Body</option>
  </select>
  <input type="submit" value="Click Here to Continue" />
  </form>

Is this possible please ??


My second question is date formating, I have

Session.LCID = 2057 'Sets locale to UK.

and my line of code is

<td><%= rstSearch.Fields("date").value %></td>

which works fine showing for example 1/12/1999

But in Access I have it formatted to show Dec-1999

So how can I get my screeen write to do the same in ASP please

Thanks

Topshed

;;;I want the drop down box to react when a selection...
Do you mean drop down box to submit?

If so:

;;;Is this possible please ??
Yes, use an onChange submit event inside your <select> tag:
<SELECT NAME='comboOne' SIZE='1' onChange="uformName.submit();">

FYI: You may find the following post helpful:
http://p2p.wrox.com/topic.asp?TOPIC_ID=38301


;;;So how can I get my screeen write to do the same in ASP please:
--------------cut n paste------------------
<%
 dVal = "1/12/1999"
 response.write MonthName(month(cDate(dVal)),true) & "-" & DatePart("yyyy", cDate(dVal))
%>
---------------------------------------------

Wind is your friend
Matt

Hi Mat

Sorry I am not with you quite ...

The three options I need are in fact column headers in my DB and what I am using are static options for my select
If I can use your code to find my column headers then fine, either way I need some more help

Regards

Topshed

when I write ;;;; I am quoting you, the next line is my answer.

You asked two questions, I gave you two answers - what part of that do you not follow?

I asked you one and you failed to answer it, why is this. The reason I asked related to your solution.

Now I dont follow you - what, you are asking different questions now? What about your originals? mmmm. lots of questions this time and its almost home time for me.

Wind is your friend
Matt

Sorry bout that

The Date thing works fine Thankyou
 to reprise the first question:-....
I want the drop down box to react when a selection is made without using a submit button as shown below

<form method="get" action= "<%= strURL %>">
  <select name="col_name">
    <option>-Select column Headers-</option>
    <option>Livery</option>
    <option>Chassis</option>
    <option>Body</option>
  </select>
  <input type="submit" value="Click Here to Continue" />
  </form>

Your excellant answer does not work for me because I want column headers (See above )
for my options unless there is a way to use your code With Column Headers

Dont be sorry. This place is where I come for help and to help others. I get turned off a post very quickly if I sense the person hasnt read my reply or falied to answer specific questions.

;;I want the drop down box to react
define react (the very first line of my very first post asked this)

Wind is your friend
Matt

When a user makes a selection from the Static drop down below

<form method="post" action= "<%= strURL %>">
  <select name="col_name">
    <option>-Select column Header-</option>
    <option>Livery</option>
    <option>Chassis</option>
    <option>Body</option>
  </select>
  <input type="submit" value="Continue" />
  </form>

I want my script to continue to the selection without them having to use the "Continue" Button
The same way as this forum jumps to the page number once selected at the bottom right of the messages

You showed me a dynamic way of doing this, but I cannot do it for this particular application dynamically because it is looking at column Headers, unless you know better

Thanx for your patience

Topshed

Problem sorted Thank you