Populating three list boxes from the database

Lamine Darbouche

Can anybody help?
I need to have three list boxes automatically populating each other, (ie
when region is selected from the first listbox, it will populate
automatically the second one which is the TOWNS and when the town is
selected is should populate the third one AREA) all data is in the database
in one table.
Any idea???
Many thanks in adavance.
Lamine

Jul 19 '05 #1

Subscribe Post Reply

2536

Ronaldo

-----Original Message-----
Can anybody help?
I need to have three list boxes automatically populating each other, (iewhen region is selected from the first listbox, it will populateautomatically the second one which is the TOWNS and when the town isselected is should populate the third one AREA) all data is in the databasein one table.
Any idea???
Many thanks in adavance.
Lamine
.

Lamine.
Are you using ASP or ASPX?
With ASPX you set the autpostback = true and use the
event selectedindexchanged of the dropdown or list.
With old ASP, you have to identify wich dropdown list was
changed. Make a javascript the gets the dropdown value
and wich dropdown was selected
(http://www.site.com/code=90&drop=a). Then you can build
the next one and so far.

Jul 19 '05 #2

Lamine Darbouche

Hi Ronaldo,
Many thanks for you reply,
I am using classic ASP, I tried your idea but without success, could you
please me with some code or example if you have one.
I have manged only two listboxes but found very hard with three listboxes.
Many thanks in advance.
Lamine

"Ronaldo" <ro*****@rsmsolucoes.com.br> wrote in message
news:13****************************@phx.gbl...

-----Original Message-----
Can anybody help?
I need to have three list boxes automatically populating

each other, (ie
when region is selected from the first listbox, it will

populate
automatically the second one which is the TOWNS and when

the town is
selected is should populate the third one AREA) all data

is in the database
in one table.
Any idea???
Many thanks in adavance.
Lamine
.

Lamine.
Are you using ASP or ASPX?
With ASPX you set the autpostback = true and use the
event selectedindexchanged of the dropdown or list.
With old ASP, you have to identify wich dropdown list was
changed. Make a javascript the gets the dropdown value
and wich dropdown was selected
(http://www.site.com/code=90&drop=a). Then you can build
the next one and so far.

Jul 19 '05 #3

Similar topics

Populating Combo Boxes

by: Derk | last post by:

I have to write a web page wht three combo boxes, all three are to be populated from a database. - there tables = Bulidings, Floors and Offices The user will choose a 'Building' from the first...

Javascript

need help populating text boxes with data from sql

by: luna | last post by:

theres no errors in my code - but it does nothing at all - its supposed to be populating text boxes!! any ideas ? (im am pretty new to all this) If Not Page.IsPostBack Then Dim search As...

ASP.NET

Populating three list boxes

by: Stephene | last post by:

New to the world of web design/php/mysql and need help please. What I'm trying to do: I would like a web page with three drop down menus each populated by a query The first represents...

PHP

Design Question: onChange Event populating a second list box

by: Paul Hadfield | last post by:

I'm looking for thoughts on the "correct" design for this problem (DotNet 2.0 - in winforms, but that's not so important). I've got two combo boxes (combo1 and combo2), both are populating via...

C# / C Sharp

Populating and Implementing 4 DropDownlist boxes on the Web Form through Web Service

by: koonda | last post by:

Hi all, I have a Project due after one week. It is a web service project. I have a Web Form which communicates to the web service and this web service communicates to the database. I have all my...

.NET Framework

Populating Combo Boxes (post-Selection)

by: Dave | last post by:

I have 3 tables of information feeding into 4 combo boxes on my main form (DR Form). I have as many list boxes (acting as text boxes) as there are fields in each one of the 3 tables. Once...

Microsoft Access / VBA

Populating 1 listbox from another listbox

by: dkohel | last post by:

I have 2 list boxes on my form. I am trying to populate listbox B with the selection from listbox A. I have set multi-select in both boxes to Extended... The user will select the items from...

Microsoft Access / VBA

Combo boxes on form not populating with stored data

by: jgoodnight | last post by:

Hi, I have a form with three combo boxes: Area, Sub-Area, and Factor. I've set up the Sub-Area combo box to list only those areas that are part of the selected area. I've set up the Factor combo...

Microsoft Access / VBA

Populating dropdown lists in Gridview from Database

by: Kalkin | last post by:

Hi i am having trouble with the following problem any help would be appreciated:: The gridview starts off with empty text boxes for input along with already populated dropdowns to choose from for...

Visual Basic 4 / 5 / 6

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA

Can faster file sharing be achieved by connecting computers simultaneously via WiFi and LAN cables

by: tracyyun | last post by:

Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...

Networking - Hardware / Configuration

Energy Model code modification to account for year dependent interest rate

by: giovanniandrean | last post by:

The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...

Python

Send Current Object to PDF

by: NeoPa | last post by:

Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...

Microsoft Access / VBA

Report value list

by: Teri B | last post by:

Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...

Microsoft Access / VBA

Access Europe Meeting - Wed 1 Nov - Using SQL Server skills to extend Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...

Microsoft Access / VBA

VBA Class Basics (Report Class)

by: NeoPa | last post by:

Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

Microsoft Access / VBA

Take a Database to the Next Level

by: GKJR | last post by:

Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

Microsoft Access / VBA