connected comboboxes - Microsoft Access / VBA

Parasyke

I have a form with two comboboxes: one for manufacturers and one for
product types. These after updating populate the results of the queries
envolved to a subform. Works great. I choose "IBM" from one combo and
"Servers" from the other and I see all IBM servers.

Here's my dilemma, the users want to choose say "IBM" from the one
combo and have the other combo only display "IBM" prodcut categories
(i.e. IBM should not be displaying something like "Barcode Scanners" in
the second combo)...

BTW both combos pull from two simple tables: manufacturers and product
types...

Any clues on this one? Thanks to anyone! Dav

Dec 7 '06 #1

Subscribe Post Reply

1340

SteMc

Hi,

I asked a similar question a while ago and someone helped by responding
with a good example. They used a city/state example where the user
selects a state in one combo box and only that states cities are
displayed in the second combobox. Rather than give an example myself I
think its only fair to let the orignal poster have the credit, so
search the past posts for my username and you should come accross the
original reply :0)

Ste
Parasyke wrote:

I have a form with two comboboxes: one for manufacturers and one for
product types. These after updating populate the results of the queries
envolved to a subform. Works great. I choose "IBM" from one combo and
"Servers" from the other and I see all IBM servers.

Here's my dilemma, the users want to choose say "IBM" from the one
combo and have the other combo only display "IBM" prodcut categories
(i.e. IBM should not be displaying something like "Barcode Scanners" in
the second combo)...

BTW both combos pull from two simple tables: manufacturers and product
types...

Any clues on this one? Thanks to anyone! Dav

Dec 7 '06 #2

pietlinden

Parasyke wrote:

I have a form with two comboboxes: one for manufacturers and one for
product types. These after updating populate the results of the queries
envolved to a subform. Works great. I choose "IBM" from one combo and
"Servers" from the other and I see all IBM servers.

Here's my dilemma, the users want to choose say "IBM" from the one
combo and have the other combo only display "IBM" prodcut categories
(i.e. IBM should not be displaying something like "Barcode Scanners" in
the second combo)...

BTW both combos pull from two simple tables: manufacturers and product
types...

Any clues on this one? Thanks to anyone! Dav

here's an article that explains it...
http://www.mvps.org/access/forms/frm0028.htm

save a link to the site. Most people here use it all the time.

Dec 8 '06 #3

Similar topics

Enter New Data In Comboboxes Only

by: Kathy | last post by:

In my custom menu one menu item opens a form to add new Makes to TblMakes and another menu item opens a form to add new Models to TblModels. I have a form that has a combobox for Makes and a...

Microsoft Access / VBA

ComboBoxes on Subform don't display value until one is clicked.

by: johnson_cy | last post by:

I am using Access 2000. My main form has a record source of a table (employeeTbl with key of . It is filtering the record results. My subform and mainform have the link child/link master set...

Microsoft Access / VBA

Searchable ComboBoxes

by: Craig G | last post by:

for months we have been dabling round looking at various 3rd party comboboxes that allow the user to type text into the combobox as a search mechanism what we've found is that the likes of...

ASP.NET

comboboxes

by: Marcin Podle¶ny | last post by:

Hi, I've a form with three comboboxes. Each of them contains the same data - all cities in my country. As you see it's a lot of data so it takes a lot of memory. I'd like to use the same...

Visual Basic .NET

complex grid with comboboxes

by: Sam | last post by:

Hi, I have a datagrid which has (amongst other stuff) 2 comboboxes columns. So far so good. The trick is that when I select a value in my first column, it must updates the items of the combobox in...

Visual Basic .NET

how to add comboboxes in the first row of datagridview.

by: ashishtarlekar | last post by:

Hi all, I have to add comboboxes in the first row of datagridview for mapping the database fields. For e.g. I have to show Id, FirstName, LastName in each comboboxes in the first row. if i select...

Visual Basic .NET

Multiple ComboBoxes, one data source

by: Matt | last post by:

Hi all, me again! :) I've now got an issue with combo boxes. Basically, I have a number of items that I want a user to pick from a single list. It's basically along the lines of: Fruit 1: ...

C# / C Sharp

Multiple Comboboxes bound to one Dataview

by: Randy | last post by:

I have a routine that creates a series of comboboxes, each of which is bound to a common dataview. Everything used to work fine, but now, when I change the value of any of the comboboxes, the...

Visual Basic .NET

Data-bound comboboxes refusing to release focus

by: Wingot | last post by:

Hey, I have a view to a database that I have created for Client Maintenance. It has a number of fields, but the important ones are Medical Condition, Bill To, and Country. I have a couple of...

C# / C Sharp

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

What is ONU?

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,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server