473,703 Members | 2,323 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Help with limiting drop-down boxes.

I am building a database in access where I have a drop down box that
relates to a text box, that part I have working but when someone
selects information from the first drop down I need it to limit the
second drop down to just the related information. Explaining this is
obviously challeging. So I'll try to draw a picture:

(drop down 1) Select number --- once selected description is populated
in text box
(drop down 2) based on first drop down number selected you get another
list of numbers to choose from which relate to other information
(drop down 3) final drop down that is limited to selections from drop
down 2

Any help that anyone can provide would be great!

Thanks,
Karin

Jun 5 '06 #1
7 2437

callawayglfr wrote:
I am building a database in access where I have a drop down box that
relates to a text box, that part I have working but when someone
selects information from the first drop down I need it to limit the
second drop down to just the related information. Explaining this is
obviously challeging. So I'll try to draw a picture:

(drop down 1) Select number --- once selected description is populated
in text box
(drop down 2) based on first drop down number selected you get another
list of numbers to choose from which relate to other information
(drop down 3) final drop down that is limited to selections from drop
down 2

Any help that anyone can provide would be great!

Thanks,
Karin


I'll try to be brief. Your 2nd and 3rd drop down boxes would have their
rowsources based on queries with parameters set to the values of the
1st and 2nd combo boxes respectivly. You would then simply do a
listbox2.requer y on the after update event of the 1st combo box, and a
listbox3.requer y on the after update event of the 2nd combo box.

Jun 5 '06 #2
On 5 Jun 2006 11:31:17 -0700, callawayglfr wrote:
I am building a database in access where I have a drop down box that
relates to a text box, that part I have working but when someone
selects information from the first drop down I need it to limit the
second drop down to just the related information. Explaining this is
obviously challeging. So I'll try to draw a picture:

(drop down 1) Select number --- once selected description is populated
in text box
(drop down 2) based on first drop down number selected you get another
list of numbers to choose from which relate to other information
(drop down 3) final drop down that is limited to selections from drop
down 2

Any help that anyone can provide would be great!

Thanks,
Karin


Leave the rowsource property of Combo2 and Combo3 blank.

Combo1, in the following code, is used to select a ClassID, for which
Combo2 will display that Classes Instructors.

Code the AfterUpdate event of Combo1 to fill the rowsource
of Combo2.
Something like this:

Combo2.Rowsourc e = "Select Instructors.Ins tructorID,
Instructors.Ins tructorName from Instructors Where Instructors.Cla ssID
= " & Me!ComboName & ";"

Change the table and field names as needed.
The above assumes ClassID is a Number datatype and the combo1 bound
column is Number also.

Then use the Combo2 AfterUpdate event, similarly to the above code, to
fill the rowsource of Combo3.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Jun 5 '06 #3

fredg wrote:
On 5 Jun 2006 11:31:17 -0700, callawayglfr wrote:
I am building a database in access where I have a drop down box that
relates to a text box, that part I have working but when someone
selects information from the first drop down I need it to limit the
second drop down to just the related information. Explaining this is
obviously challeging. So I'll try to draw a picture:

(drop down 1) Select number --- once selected description is populated
in text box
(drop down 2) based on first drop down number selected you get another
list of numbers to choose from which relate to other information
(drop down 3) final drop down that is limited to selections from drop
down 2

Any help that anyone can provide would be great!

Thanks,
Karin


Leave the rowsource property of Combo2 and Combo3 blank.

Combo1, in the following code, is used to select a ClassID, for which
Combo2 will display that Classes Instructors.

Code the AfterUpdate event of Combo1 to fill the rowsource
of Combo2.
Something like this:

Combo2.Rowsourc e = "Select Instructors.Ins tructorID,
Instructors.Ins tructorName from Instructors Where Instructors.Cla ssID
= " & Me!ComboName & ";"

Change the table and field names as needed.
The above assumes ClassID is a Number datatype and the combo1 bound
column is Number also.

Then use the Combo2 AfterUpdate event, similarly to the above code, to
fill the rowsource of Combo3.


This sounds a lot like what I need too, but I'm so new, I don't really
understand. :(
Is there a good tutorial with a glossary and SQL syntax explained in
plain english to start with? I'm guessing these are SQL statements?
I wanna learn, but I'm not sure where to turn first.
I'm barely past using wizards and drag and drops, peaking into property
box statements. The termionology is still overwhelming :(
Some pointing in the right direction would me much appreciated!!! TIA

Jun 5 '06 #4

co********@yaho o.com wrote:
fredg wrote:
On 5 Jun 2006 11:31:17 -0700, callawayglfr wrote:
I am building a database in access where I have a drop down box that
relates to a text box, that part I have working but when someone
selects information from the first drop down I need it to limit the
second drop down to just the related information. Explaining this is
obviously challeging. So I'll try to draw a picture:

(drop down 1) Select number --- once selected description is populated
in text box
(drop down 2) based on first drop down number selected you get another
list of numbers to choose from which relate to other information
(drop down 3) final drop down that is limited to selections from drop
down 2

Any help that anyone can provide would be great!

Thanks,
Karin


Leave the rowsource property of Combo2 and Combo3 blank.

Combo1, in the following code, is used to select a ClassID, for which
Combo2 will display that Classes Instructors.

Code the AfterUpdate event of Combo1 to fill the rowsource
of Combo2.
Something like this:

Combo2.Rowsourc e = "Select Instructors.Ins tructorID,
Instructors.Ins tructorName from Instructors Where Instructors.Cla ssID
= " & Me!ComboName & ";"

Change the table and field names as needed.
The above assumes ClassID is a Number datatype and the combo1 bound
column is Number also.

Then use the Combo2 AfterUpdate event, similarly to the above code, to
fill the rowsource of Combo3.


This sounds a lot like what I need too, but I'm so new, I don't really
understand. :(
Is there a good tutorial with a glossary and SQL syntax explained in
plain english to start with? I'm guessing these are SQL statements?
I wanna learn, but I'm not sure where to turn first.
I'm barely past using wizards and drag and drops, peaking into property
box statements. The termionology is still overwhelming :(
Some pointing in the right direction would me much appreciated!!! TIA


Jun 6 '06 #5

There is a Microsoft article "Basing one combo box on another" at
http://office.microsoft.com/en-au/as...730581033.aspx.

Jun 6 '06 #6

Mary wrote:
There is a Microsoft article "Basing one combo box on another" at
http://office.microsoft.com/en-au/as...730581033.aspx.


Thanks,
I read through that few days ago, it talks about doing it through
forms, which I've done before. I'm sorry I didn't make that clear.
I would have sworn I've seen it done with just using preset text
lookup, and a query feeding into a table, without making a form. I
don't have the dadabase I was looking at few months ago to deconstruct
and see what they did. I remember seeing a long dropdown list in ine of
the tables that filtered another dropdown further down in the same
record. Then I went looking for a table for the first dropdown, and
realized it was just a text list with preset values, no table, which
surprized me a little, since I've always done it with a table through a
form. It was done by some professional database guy...

Can it be done at all without using forms, in access?

Right now, not finding anything addresing that in help and tutorials,
I'm not sure if it's because I don't remember something right, and it
can't be done at all, or if tutorials don't want to teach a possibly
improper or disantvageous way of doing something.

Jun 6 '06 #7
With tables in Access you can specify a lookup against a field, in the table
design. That lookup can have the same rowsource that is valid in a combobox
or listbox - value type, field list, or SQL, or table name.

I havent' seen any way, in the table design, to make another field, that
also uses a dropdown list (looiup), filter its list based on the contents of
the first field.

Curious to know if anyone knows how to do such a thing.
Jun 6 '06 #8

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

Similar topics

3
1387
by: Bruce D | last post by:
Here's the breakdown: MySQL 4.0.12 Table: Assignment (indexes are created on proper fields) 419,234 records Table: Finders (indexes are created on proper fields) 5,345,657 records My user wants to be able to do a wild card search on lastname in the finders table. So, I wrote the following query. SELECT Finders.Lastname, Assignment.currentcard FROM Finders JOIN Assignment on Finders.assignmentid=Assignment.assignmentid WHERE...
7
3983
by: pkruti | last post by:
Below is a stored procedure i am working with and i am trying to drop the yesno_holding table if it exists but how do i add it back? Meaning i want it to drop if it exists but i want to add it back if it doesnt exist. the reason why i have to drop it is because when i run the stored procedure it creates mulitple rows with the values in them but in my report it takes the top row and insert those values into the report and i dont want that i...
1
1729
by: Ron | last post by:
I have a pre-printed form that I've basically duplicated in Access 2000 with the form wizards. It uses a main form for the basic info on a client, then a subform for the transaction lines. I've tweaked it "just a bit" with code for defaults and stuff, but otherwise, it's pretty much the way the wizards created it (both main form and sub-form). However, I need to either limit the number of transactions my user can input, or limit the...
4
1621
by: N J | last post by:
Hi, I ahve developed a program using access and am distributing it using MDE's, I ahve had many requests for a demo. I was thinking of limiting the number of records to say 100? If anyone has any idea's that'd be great, thanks...Nick J --
1
1350
by: Gary | last post by:
Hi, I am working with drag and drop functionality. I am draging a button and dropping in a text box. I am able to drop only button text value. 1) Can i drop button itself? 2) If i work with a single form in a project having it work fine but in my project my start page is login - and drag and drop does not have so it displays an error "dragdrop registration failed" and i cant include my in my drag and drop page too..
7
2210
by: teddysnips | last post by:
Table DDL below: The tables I have contain Timesheet information. Each row in the tblTSCollected table contains an entry for an employee into the timesheet system, specifically by scanning the barcode on their badge. A whole bunch of business logic periodically attempts to "pair" these into logically matched scans. For example, some employees will scan in and out of a single place of work. For these there will be a row written to...
0
1323
by: josh.23.french | last post by:
Here's the code i have: $db = array(); //main array $db = array(); //table `main` $db = array('id'=>0, 'username'=>'joshfrench','userpass'=>'password','userlevel'=>'admin'); //row $db = array('id'=>1, 'username'=>'bob_smith','userpass'=>'psswrd','userlevel'=>'user'); //row
11
7873
by: tracy | last post by:
Hi, I really need help. I run this script and error message appeal as below: drop trigger log_errors_trig; drop trigger log_errors_trig ERROR at line 1: ORA04080: trigger 'LOG_ERRORS-TRIG' does not exist drop table log_errors_tab;
4
1550
by: Andrew | last post by:
I want to create a set of Activity Diagram controls for process control. I need to create a base Diagram control that acts as a container for the Activity controls ( StartPoint, EndPoint, Actvity, Decision, Message,...). How do I implement it such that the only place I can drop an Activity control is on a Activity Diagram? I'm an experienced Delphi developer and I'm just getting started in C#. There appears to be significant...
53
8399
by: souporpower | last post by:
Hello All I am trying to activate a link using Jquery. Here is my code; <html> <head> <script type="text/javascript" src="../../resources/js/ jquery-1.2.6.js"</script> <script language="javascript" type="text/javascript">
0
8758
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9121
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8962
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6588
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5922
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4432
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4687
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3123
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2069
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.