473,320 Members | 1,879 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Filtering results from MultiSelect Form field.

Hi,

First, thanks to all who have helped me over the last few weeks !!

I have a form that allows the user to select multiple options.

These are user names:

Fred S
Bob D
Paul G
Dave O

When the form is submitted, I'm getting the details using

user = request.form("user")

this is returning the mutliple options.

What I would like to do is pass all the options to 'user' but at one
point on the results page only show the first user selected, not the
multiple selection.

Can this be done ??

Thanks
Jul 19 '05 #1
2 1229
As an update:

I don't need to extract each individual user.

I want to create 2 variables:

user1 = first user from the multiple selection

user2 = all selected users.
(I can get this info - If I select 3 people, I get: Fred S, Bob D,
Paul G)

Cheers
On Fri, 20 Aug 2004 08:01:29 +0000 (UTC), TomT <to**@adslweb.co.uk>
wrote:
Hi,

First, thanks to all who have helped me over the last few weeks !!

I have a form that allows the user to select multiple options.

These are user names:

Fred S
Bob D
Paul G
Dave O

When the form is submitted, I'm getting the details using

user = request.form("user")

this is returning the mutliple options.

What I would like to do is pass all the options to 'user' but at one
point on the results page only show the first user selected, not the
multiple selection.

Can this be done ??

Thanks


Jul 19 '05 #2
Sorted using :

<%
user = request.form("user")
user1 = Split( user, "," )

response.write "All Selected Users " & user & "<br>"
response.write "Main Event Contact " & user1(0) & "<br>"
%>

However I know have a new problem..

If I select 3 users:

Paul, Dave, Mark

Is there any way to have the first name clicked as the first name in
the results ?

IE: If I click Paul, then Mark
the results would be Paul, Mark

Howvever, If I click Mark, then Paul
Then the results would be Mark, Paul
Thanks
Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Jason | last post by:
I am trying to filter records in a primary form based on records in related tables. The data in the related tables is being displayed in the primary form through subforms. To be more specific, I...
1
by: mstery | last post by:
I have a report generated via an ID selection made in a dropdown on a form. The report filters by an on click event in a preview report button on the form. Everything in the report, including...
19
by: Chantelle | last post by:
I've got this A2K DB that has a continuous form that lists Suppliers and their details. The form has a field for each supplier that holds several Keywords that reflect the suppliers products or...
8
by: Ragbrai | last post by:
Howdy All, I have a query that is used for filtering results to be used in a combo box. The query needs to test fields from both a table and then unbound text boxes on the form that also contains...
2
NeoPa
by: NeoPa | last post by:
CHAPTER 1 - TABLE OF CONTENTS (Including attached database) CHAPTER 2 - INTRODUCTION CHAPTER 3 - TABLE LAYOUT CHAPTER 4 - FORM LAYOUT CHAPTER 5 - FORM MODULE CHAPTER 6 - CODE DISCUSSION (FILTER...
5
by: jonosborne | last post by:
Hi, i have managed to filter a report based on selections made in a list box but am totally confused with a message box that appears everytime i run my report. Let me explain (i apologise for...
2
Scott Price
by: Scott Price | last post by:
Hello again! Running MS Access 2003 on WinXPproSP2. Now I'm trying to re-filter my subform based on the currently shown Year field (the filter applied on open restricts to 15 records relating...
1
by: datasec23 | last post by:
Hi... I really appreciate your help with my question, I am pulling my hair out on this. I have not been able to find an answer on the other posts. I am using Access 2000. I have a form that...
6
by: topher83 | last post by:
Hi Im trying to create a form to search a hardware database for items, the form consists of two boxes, a dropdown box and a text box. The user needs to choose a field from the dropdown box and then...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.