Hi,
I wonder if any one can help, I'm pretty new to Access and I can't
figure out how to change the contents of a combo box based on a
selection I make in another.
Let me explain I have a combo box where I can select a continent from
a continent table. I would like the contents of a second combo box to
reflect my choice of continent and list countries that are in that
continent. These countries are in separate tables/queries (actually a
query based on the table that orders the countries alphabetically) .
The database contains the following tables/queries
Continent Table: SOURCE OF FIRST COMBO BOX
Continent ID
Continent
European (American, Asian) Countries Tables:
Europen Country ID
Europen Country
European Country List (Query) SOURCE OF SECOND COMBO BOX
Eurpean Country (ordered sourced from above table)
I haven't quite grasped how Access passes on information from one area
to another so could anyone describe as simply as possable how to go
about it would be greatly appreciated.
Regards,
Jeff 2 3061
Jeff Barry wrote: Hi,
I wonder if any one can help, I'm pretty new to Access and I can't figure out how to change the contents of a combo box based on a selection I make in another.
<snipped> http://www.mvps.org/access/forms/frm0028.htm
This site should be your first port of call when you need to work something
out. jb****@picr.man .ac.uk (Jeff Barry) wrote in
news:b8******** *************** ***@posting.goo gle.com: Hi,
I wonder if any one can help, I'm pretty new to Access and I can't figure out how to change the contents of a combo box based on a selection I make in another.
Let me explain I have a combo box where I can select a continent from a continent table. I would like the contents of a second combo box to reflect my choice of continent and list countries that are in that continent. These countries are in separate tables/queries (actually a query based on the table that orders the countries alphabetically) .
The database contains the following tables/queries
Continent Table: SOURCE OF FIRST COMBO BOX Continent ID Continent
European (American, Asian) Countries Tables: Europen Country ID Europen Country
European Country List (Query) SOURCE OF SECOND COMBO BOX Eurpean Country (ordered sourced from above table)
I haven't quite grasped how Access passes on information from one area to another so could anyone describe as simply as possable how to go about it would be greatly appreciated.
Regards,
Jeff
First of all you will find it easier, (much easier), if you put
all your countries into a single table With three fields,
Continent ID, CountryID, Country.
Create a continents combo, cboContinents.
Create a combo for the countries, cboCountries.
Then you set the rowsource for the cboCountries to
="SELECT country from countries where continentID = " &
cboContinents"
put me.cboCountries .requery in either the
cboContinents_A fterUpdate event or the cbocountries_On Enter
event.
Use the form.
Bob Q This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Stewart Midwinter |
last post by:
I've got an app that creates an object in its main class (it also
creates a GUI). My problem is that I need to pass this object, a
list, to a dialog that is implemented as a second class. I want to
edit the contents of that list and then pass back the results to the
first class. So my question is, can a method in one class change an
object in another class?
If the answer is no, I suppose I could pass in the list as an argument
when I...
|
by: techie |
last post by:
Hi All,
I have a portal working on an intranet for a company. The portal was
designed keeping in mind the resolution of 1024*768. I am including a
..css file in all the files. Now i have to make the file compatible for
both 1024*768 and 800*600 resolutions. I don't want to change all the
files to include an alternate css. Can i write some javascript
conditions in the css files to change the class definitions based on
resolutions. I am not...
|
by: Glenn Mulno |
last post by:
Hi,
I am trying to create a report page for several teams. Each team runs the
same reports but the reports use different values.
For a while this was getting insane everytime I updated the queries I had to
change them in many places. Then I started using server side includes to
keep me from changing some items in multiple places.
There is still some double (quadruple) updating going on though when I make
|
by: nsteele84 |
last post by:
Hi
I need to clear the contents of a pulldown and then load new contents
into it. Is this possible in Javascript? If so how?
Thanks
Nick Steele
|
by: Antoine Janssen |
last post by:
hi,
I would like to create two combo boxes. In the first one you can select
a user in the second one you can select a project. To simplify the
selection i would like to shorten the project list by just presenting
the projects the selected user is working on (using a where clause with
the userid filled in). Does onyone know how to achieve this?
Kind Regards,
| |
by: Lorenzo Thurman |
last post by:
I would like to have an element, a text string, change into a select
when a mouseover occurs and then change back to text when a selection is
made or when a mouse out occurs. I looked a t using dojo for this,
http://dojotoolkit.org, but this will end up on a production server,
where dojo is not installed and cannot be installed. So, I need another
solution. Can someone give some pointers on how this might be done?
TIA
|
by: free4trample |
last post by:
First of all let me say that I know very little about javascript.
what i need to do is to write a javascript functin which will change
the background color of the table rows based on entrees in the table.
See an example of the webpage that the script will work with here:
http://igorpetrusky.awardspace.com/RunStats.html
now, at the top there will be 3 buttons, which will call javascript
functions that will operate on tables 2 through N. ...
|
by: seangibson |
last post by:
Is there a way to change the appearance of my form based on which option button is selected? I am using a form to input data into a table of transactions. There are basically 3 types of transactions (the type of which I would specify with an options button) and, though they all share common fields, some entries do not require all of the fields to be populated. For these I'd like for some of the combo boxes (my form uses combo boxes...
|
by: kcdoell |
last post by:
I have 5 cascading combo boxes on a form. Below is a sample of my vb in the first combo box:
Private Sub CboDivision_AfterUpdate()
'When the Division is selected, the appropriate Segment list will
'display in the drop down list of CboSegment
With Me!
If IsNull(Me!cboDivision) Then
|
by: Binod Bihari |
last post by:
I have two combo box.Like combo1 and combo2.In combo1 i have list of countries.On select of specific country i would like get the respective district options in combo2.
using java script
Thanks & Regards
|
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...
| |
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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...
|
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();...
| |
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...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |