473,698 Members | 2,869 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Combo Box & DatSource

Hi ,
I've 24 Combo Box in a Group , connected to the same DataSource
(ArrayList) : easy way to fill Combo .

The pb i've , is that when i select an item in 1 combo then all other
23 will display the same entry , and of course i don't want that .

Is there something quite simple that i could do force them , not to
sync ?

Thanks
Jacques

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 20 '05 #1
2 1115
i think if u link it via the datasource they are all bound to the same
currencymanager (well i think thats what u call it.. im sure the experts
will correct me on the correct term) , hence all being in sync. Sort of like
how u can control all textboxes to scroll records at the sametime.

You could use the datareader to loop and then append the data to each
different combobox within the same loop.. it shouldnt be linked to any
datasource then...

<Jacques> wrote in message news:OG******** ******@TK2MSFTN GP10.phx.gbl...
Hi ,
I've 24 Combo Box in a Group , connected to the same DataSource
(ArrayList) : easy way to fill Combo .

The pb i've , is that when i select an item in 1 combo then all other
23 will display the same entry , and of course i don't want that .

Is there something quite simple that i could do force them , not to
sync ?

Thanks
Jacques

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

---
Outgoing mail is certified Virus Free. (well i'd like to think it is.. )
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.723 / Virus Database: 479 - Release Date: 19/07/2004
Nov 20 '05 #2
Hi,

In addition to Mike's comments. The currencymanger will keep the
comboboxes in sync. Create a new dataview for each combobox and bind each
combobox to a different dataview.

Ken
------------------
<Jacques> wrote in message news:OG******** ******@TK2MSFTN GP10.phx.gbl...
Hi ,
I've 24 Combo Box in a Group , connected to the same DataSource
(ArrayList) : easy way to fill Combo .

The pb i've , is that when i select an item in 1 combo then all other
23 will display the same entry , and of course i don't want that .

Is there something quite simple that i could do force them , not to
sync ?

Thanks
Jacques

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
4108
by: Prakash Wadhwani | last post by:
I have a form (continuous) with a few fields : First Name, Last Name, Policy Number, etc. In the form footer I have a combo box for LastName which has 3 TEXT fields: LastName, FirstName & Policy Number When the user clicks a LastName on the Combo it should seek & position me on that record on the continuous form. That's ok till here. The problem is: It always position me on the 1st ocurence of the
2
6774
by: Dman | last post by:
Having trouble in Access XP. I want to display the customers name, city and phone number in a Combo Box but the but the formatting is lost – eg (123) 456-7890 is displayed as 1234567890. Any idea how to format the control. From what I can see, the combo box has a format option but I am referring to the 3rd column. The results display properly within the underlying query… it’s the Combo Box that loses the formatting. Thoughts? ...
15
2966
by: sara | last post by:
Hi I'm pretty new to Access here (using Access 2000), and appreciate the help and instruction. I gave myself 2.5 hours to research online and help and try to get this one, and I am not getting it. Simple database: I want to have a user enter Supply Orders (just for tracking purposes) by Item. The user may also enter a new item - "new" is a combination of Item, PartNumber and Vendor - they could have the
0
789
by: Nikolay Petrov | last post by:
I have a SQL database with two tables: Contacts and Companies On form where the user should edit the Contact details there is a combo box from which he can select the contact's company. I am filling dataset using a strored procedure. To the moment I have managed to display the name of the company currently assigned to the contact. What I want the combo box to display the list of all companies in Companies table, so he can select to which...
1
1557
by: jason.teen | last post by:
Hi, Just wondering if you can mix values in a combo box. I want to fill it up with some query such as: select name from tblDetails; and that may produce a combo box with: "John" "Peter"
2
1129
by: hari kumar | last post by:
sir, I have some about the codings of combo&listboxes. first is when i select the combo then all the fields are automatically displayed. next is when i click the listbox then all the files including the combo is displayed. I am always using in ADODC component to connect the fields. how we use only in ADODC connection without placing ADODC component in the form. Please help me . This is very urgent Thanking You ...
2
7047
by: biganthony via AccessMonster.com | last post by:
Hi, I decided to install Office 2003 Service Pack 3 on my home computer to test (in full knowledge that there may be some issues with it). After installation, I have noticed that with a small database I wrote for home, the combo boxes and listboxes no longer display the bound column. For example, on a form I have a combo box based on a table called 'names'. The two columns in the combo box are ID and Surname. The combo box and list box...
1
1345
by: hsangi | last post by:
I have a Main Form with a combo box at the top. The combo box has 6 different values it reads from a table. I have 6 subforms which I have already built. Depending on the value selected in the combo box I want to display directly below the combo box its corresponding subform. Can someone please give me an example of how I would do this?
1
1331
by: gsbatch1 | last post by:
Relatively new to Access, 1 year of self taught. I have a Form (Form1) that is Unbound, with the main Combo Box, (SupCombo) that has its Row Source : Select qrySupervisors.Supervisor From qrySupervisor qrySupervisor 1 column Supervisor Once the supervisor is selected, the Second Combo Box (AgentCombo) populates with the Agents assigned to that Supervisor. AgentCombo's Row Source is "qryAgent" qryAgent 2 Columns Agent
0
8603
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9157
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8893
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,...
0
7723
agi2029
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...
1
6518
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 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...
0
5860
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();...
1
3045
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2328
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2001
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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.