Re: Access 2003 question:
- From: "RicksPlace" <ofbgmail@xxxxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Mon, 1 Feb 2010 19:31:11 -0500
Hi Charles: Well, in general, I use Sql Server but the procewss for this
senario might be something like: You have the first combobox displayed. The
user arrows up and down in the combo box. When they click on an item you
display the second combo box with the desired items loaded from the database.
To do that you initially set the second combo box to visable false. Then when
the user clicks an entry in the first combo box, you use the selected item to
access the desired entries from the base based on the item selected in the
first combo box. That or you can use a button to do the same thing.
Rick USA
----- Original Message -----
From: Charles Black
To: programmingblind@xxxxxxxxxxxxx
Sent: Monday, February 01, 2010 7:22 PM
Subject: Access 2003 question:
I have an access 2003 question. If I have a form with two comboboxes on it.
The first combobox is automatically filled in with data. The second is filled
with data: although it is a larger list than is needed. After you select the
option you want from the first combobox, the second combobox should contain
only those items related to the choice you made in the first combobox.
For example,
If you have 'a b c' in the first combobox AND YOU CHOOSE 'A', ONLY A 'D E F'
SHOULD SHOW IN THE SECOND COMBOBOX. If you have a 'b' in the first combobox,,
then a 'g h' should appear in the second combobox. If you have a 'c' in the
first combobox, then an 'I j k l' should appear in the second combobox. How
might I achieve this using tools in Access?
Charles E. Black
charlesblackusc@xxxxxxxxx
Other related posts:
