Hi,
I have a problem with dropdown list in combo box. Combo box row source returns 3 fields data likes revision, type, description. In these 3 fields, only revision may have duplicate number but type number is different. Bound column of this combo box is revision. Column count is 3 and width is 0,0,2. I need to show only description of that revision.
For example, in dropdown list returns data like :
1,1,'apple',
1,2,'orange'
When I choose second line 1,2,'orange' in combo box it should show 'orange' but it always show 'apple'
Could anybody tell me how to fix this?
Sophanna
8 1452
The reason is because you have duplicates in revision. You need to use a unique field as the bound field.
Hi Rabbit,
As you said, in my list for revision or type alone may have duplicate value, then I take description as bound column, but all the value of combo box will change to the latest value that I just select from dropdown list.
Could you give me ideas on how to solve this?
Sophanna
It sounds like you didn't set the control source.
You are trying to use a Combobox to select two values. It's only capable of selecting one all by itself. It will take some VBA magic to get this to work the way you want it to. If you don't want to resort to VBA, you'll need to split out the Revision and Type fields into two separate ComboBoxes.
Google returned this article on how to attempt it if you are up for some programming, it basically creates a composite key for the two columns and splits them apart in code: http://answers.microsoft.com/en-us/o...9-820d9b107c2c I haven't tried this, so I don't know how well it will work.
Would it be possible to change the bound column to column 2?
Hi twinnyfo,
Column 2 is type field, and it also has duplicate value. Only revision and type could make each row unique.
Hi Rabbit,
I already set control source to other table revision field.
All the boxes shouldn't change value whenever you select a new item unless the control is unbound.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Joseph Barron |
last post by:
Here is a SIMPLE problem that I'm trying to solve.
It works in Netscape 6.2, but IE6 gives ""No such interface
supported."
Below are page1.htm and page2.htm .
In page1.htm, there are two...
|
by: Doslil |
last post by:
I have a form which has a subform.In the main form I have only one
field (this is a drop down list and has a query attached to it) which
selects empno,Name from the EmployeeInformation table.
...
|
by: Mark |
last post by:
I have two dropdown lists. Both have autopostback set to true. In both
dropdowns, when you select an item from the list, it redirects to the Value
property of the dropdown. Nothing fancy.
...
|
by: Paul |
last post by:
I have a dropdown list box and a button on a web form, the autopost back is
false for the dropdown list box and button. When the button is pushed the
selection in the dropdownlist box is lost,...
|
by: jung_h_park |
last post by:
From: jung_h_park@yahoo.com
Newsgroups: microsoft.public.dotnet.framework.aspnet
Subject: Dropdown List not retaining its SelectedValue
Date: Mon, 26 Jun 2006 21:02:57 -0700
Hello,
My...
|
by: er1 |
last post by:
Hi all,
I have created a double dropdown list. Based on the first list selection, second list populates (this works fine). I have a submit button, which when clicked should run a select query...
|
by: yasodhai |
last post by:
Hi,
I used a dropdown control which is binded to a datagrid control. I
passed the values to the dropdownlist from the database using a
function as follows in the aspx itself.
<asp:DropDownList...
|
by: fezzabett |
last post by:
i have one question. i have two different dropdown list. one to select members,and another one to select department. so i want function when i click on one button for example i named it 'add another...
|
by: fish919 |
last post by:
Hello All,
I am creating a date base in access. I want to create a dropdown list box that is connected to another dropdown list box.
You start with a dropdown list that has 5 choices and each of...
|
by: abhi3211 |
last post by:
i am using java inside java script page.
in that page i want to use two dropdown list.
in first dropdown list i am getting data from ms-access database.
in second dropdown list i want to get data...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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...
|
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
|
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...
|
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...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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...
|
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,...
|
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,...
| |