Dependent combo boxes

I would like to put 4 combo boxes on a user form, each one limiting the
results to the set from the previous combo box. Can anyone please offer some
guidance ?

Thanks !

Please answer here in the NG.

Nov 13 '05 #1

Subscribe Post Reply

4988

Paul

No problem,

Assume they 4 combos are called combo1, combo2, combo3 and combo4

In the criteria of the rowsource of combo2, refer to combo1:
[forms]![formname]![combo1]

make sure to do combo2.requery on the OnEnter Event of combo2

In the criteria of the rowsource of combo3, refer to combo2:
[forms]![formname]![combo2]

make sure to do combo3.requery on the OnEnter Event of combo3

In the criteria of the rowsource of combo4, refer to combo3:
[forms]![formname]![combo3]

make sure to do combo4.requery on the OnEnter Event of combo4

That should do it.

HTH
Paul
"me" <no***@cox.net> wrote in message news:SmKkd.1534$IZ2.17@lakeread06...

I would like to put 4 combo boxes on a user form, each one limiting the
results to the set from the previous combo box. Can anyone please offer
some
guidance ?

Thanks !

Please answer here in the NG.

Nov 13 '05 #2

by: lorirobn | last post by:

Hi, I have a form with several combo boxes, continuous form format, with record source a query off an Item Table. The fields are Category, Subcategory, and Color. I am displaying descriptions,...

Microsoft Access / VBA

Wierd behavior of combo boxes on tab control

by: Tom | last post by:

I have some very strange issues with combo boxes on a tab control. Here's the scenario: I have a Windows Forms form that has a tab control on it, with two (2) tabs. Tab 2 happens to have a number...

Visual Basic .NET

Synchronized combo boxes, dependent field not showing all options after migration of data

by: Miguel | last post by:

I have an order entry database with two forms. One is for new orders the other is to update orders. The forms are identical except that one is strictly order entry. On both forms are three sets of...

Microsoft Access / VBA

Combo boxes dependent on other combo boxes

by: NateDogg | last post by:

This is what I am using to filter my combo box based on what is selected in the previous box. Open the properties for the second combo box. Next to the 'Row Source' property, click on the '...'. ...

Microsoft Access / VBA

TO Dependent listboxes on access forms

by: annivanova | last post by:

Hi, I saw posts in Dependent listboxes on access forms, which problem is very similar to my. I’m from Bulgaria and working over to create an MS Access application. I used in my project given code...

Visual Basic 4 / 5 / 6

Getting a 3rd dependent combo box to work

by: Cerian | last post by:

Hi there, I'm having trouble getting my 3rd dependent combo box to work in Access 2003. I have three dependent boxes named cbogroup, cbosection and cbofunction. Each one is dependent on the...

Microsoft Access / VBA

updating subform via selection of combo boxes

by: Dave | last post by:

I want to put the information that the user selects in my combo boxes into a subform that lies on the same form as the combo boxes. Thanks for your help already, Dave

Microsoft Access / VBA

main form with subform and combo boxes

by: Dave | last post by:

Hello all, First I'd like to apologize...This post was meant to be put in my previous post, but I tried many times without success to reply within my previous post. Now here goes... I have a...

Microsoft Access / VBA

Dependent combo boxes and also unsure if need a sub-form???

by: deanndra | last post by:

First, I want to say thank you to Scott and the others who replied to my first post here. I had to put that database on hold for the moment when I was tasked with a new one. I am building another...

Microsoft Access / VBA

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

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

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

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

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

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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

General

Similar topics