473,511 Members | 15,624 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

unique comboboxes

23 New Member
hi :)

i have more than 10 comboboxes with same query source
how can i control value selection
so if any value selected in any combo, the user cant select this value in other combo

(again i have more than 10 combo)

thanks
Sep 7 '16 #1
2 782
Seth Schrock
2,965 Recognized Expert Specialist
There are two ways to do this. You can either change the row source to filter out selections based on the other combo boxes, or you can do this in VBA and check in the Before_Update event of each combo box to see if the new value is selected in any of the other combo boxes and cancel the event it if is.
Sep 8 '16 #2
zmbd
5,501 Recognized Expert Moderator Expert
See if this article fits the bill:
home > topics > microsoft access / vba > insights > cascading combo/list boxes
Sep 8 '16 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

4
1959
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...
0
1920
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...
5
1330
by: Henry | last post by:
Please forgive me if I have missed an obvious answer to this question... I am looking at controls like comboBoxes, ListBoxes, and Trees and trying to understand how to associate what is viewed in...
4
2950
by: Jazper Manto | last post by:
hi i bounded the same dataview to 2 different comboboxes. now, when i change the selectedIndex of combobox1, it automatically changes the selectedIndex of combobox2. does this mean, that the...
2
11437
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: ...
3
1776
by: BASSPU03 | last post by:
I had to present my DB today, but was granted a chance to fix something about it. In order to fix something, I added something...something that is giving me more trouble than it should. I have to...
2
1980
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...
1
1944
by: OllyJ | last post by:
Hi guys, probably an easy one for you. I know how to limit a row source sor a combo on a form (setting unique values). The problem i'm having is that the query is the record source for a...
4
1371
by: axplains | last post by:
Hello everyone, I would like too generate a number of comboboxes at runtime and then pass them to a Sub, like this: For i = 0 to maxnumber Dim cbo As New ComboBox() cbo.Name = "cbo" & i ...
2
5914
by: Jeroen3131 | last post by:
I have a Form with four comboboxes (cboSelectDepartment, cboSelectOperation, cboSelectModel and cboSelectVariant), a Listbox (selectionList) and a Button (cmdSelectStep). The Listbox displays a...
0
7252
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,...
0
7153
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...
0
7432
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...
1
7093
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...
0
7517
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...
1
5077
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...
0
3230
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...
0
3218
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
452
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...

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.