2 Column Combo Boxes in display.

I have it set up so in the combo box drop down that it shows both columns that I want displayed but when an option is chosen, only the first column shows up in the box. I need both to show up. I searched the forms and found a few things but I still wasnt able to complete it. Any tips

Sponsored Links:

Related Topics

Restricting values in combo boxes
Here's another one. I promise I'm not planning on carpet bombing this forum with queries.

When adding a combo box to a field in a table, is it possible to restrict the values so that they include only a subset of the entries in the relevant column from the source table?

For example, Column A in Table 1 might contain a list of names, while Column B contains check boxes to state whether the people named are still alive. Column A in Table 2 might then contain combo boxes linking to Column A in Table 1. Would it be possible to restrict the values in the combo boxes so that they contained only names of people who were still alive


Combo Box help
I have a combo box that gets its values from the second column in a two column table, with the first column being numbers and the second being words. I just made the width of the display of the first column 0 so it wouldn't show up in the combo box. Whenever I select a word from the combo box, the number from the table shows up in the spreadsheet that the form is attached to. How to I make the spreadsheet display the word (ie how do I make it display the values in the second column instead of the first).


2 Column Combo Boxes in display.
I have it set up so in the combo box drop down that it shows both columns that I want displayed but when an option is chosen, only the first column shows up in the box. I need both to show up.

I searched the forms and found a few things but I still wasn't able to complete it.


Combo Box to display thee different text boxes
I want to display all the current fields on my Form.Joe from a Combo Box. Example:
My combo box "Product" is taken for a table which contain 3 fields: FLD1, FLD2, FLD3. so, if you click on the combo box you see the first record. Now, being that these records are very long, I want the user to be able to see in on the Form, because they cause see it on the combo box!

So, I want to take the Combo FLD1 and store the data and make a text box to display the test in it and do the same for the other two fields.

So, as the users click on the combo box the wording would also display on the form in three different text boxes. How do I store that information in the Combo Box to be displayed on the current Form in three separate text boxes.


Combo Boxes 3 (multiple column combo boxes)
Now the third part will teaches you multiple column combo boxes. (video tutorial)


Selective Display of a List of items into A Combo Box
I have a table with multiple columns. Columns 1,3,5, etc are lists of names that I want to be used to display in combo boxes. The rest of the columns are corresponding columns to 1,3,5 which are of type Yes/No selection to determine if I want the name hidden or not.

Is there a way that I can get names from this list to display in a combo box, but make sure the ones that have the Yes/No box checked to be hidden?

So far I've been able to list the names in a combo box from a single column,
list the names in a combo box from multiple columns,
list the names in a combo box from a single column and hiding some of the options by using a query,
But when I try to list the names from all columns, it doesn't do what I want.

What should I do? I'm kinda


Set default value to combo box
I have got a combo box which I type a product code into and then text boxes which display the spec of that product. Is there any way I can set the default value of the text boxes to be a column in the combo box (eg [combo40].[column](1) ). I want to do this so it pulls brings up the default spec of the product but can be edited and saved on another table


Getting display value of lookup column?
How do you programmatically get the display value of a lookup column?

I have a lookup column that works fine, but when I try to get the value through vba, I can only get the bound value (a number). I tried doing it the way I would for a combo box: [field].Column(1), but that didn't work. I need the display value so I can use it in a Dlookup function on another table


Display column headings in a combo box
On an Access 2003/XP/2000/97 form, I've created a combo box whose values are populated by a query. I want to see the column headings so that I can differentiate between the various columns. How do I display the column headings in a combo box?


ComboBox Display
I currently have a form with 2 combo boxes on it. One combo box has a list of participants that is pulled from a participant table. The other combo box are referrals, which a participant can have many of.

When you have both combo boxes selected there is a "Report" button that displays the appropriate report. Everything works as intended, but I am having a problem with the display problem of the 2nd combo box.

The query of the 2nd combobox has 4 fields (ParticipantID, RSID, Name, Date). The Criteria of the ParticipantID is what determines what records to display in this combobox. right now when you click the Referral you want in the 2nd combo box (example: 10 Rick Armstrong 5/11/2012) , After selection it puts only the RSID in the combobox to display.How can I fix this to display everything you selected, but still use the RSID to get the appropriate record.


Multiple column display on form
Is there a way to display multiple columns in a combo box after selection?

I have a combo box which contains 4 columns and displays 3 columns during the selection process but only displays the first visible column when a selection is made.

If it is not possible, is there a way to post the remaining 2 columns into two additional text boxes on the same form?

Access 2007

table consists of : id, statute, description, level


Combo Boxes always display first record of table
Maybe there is an easy fix for this.I have a form with several combo boxes bound to a table. When I open the form, the combo boxes always default to the first record in the table. I want them to be blank/on a new record in the table so the person can start choosing their info and submit. I have tried setting default values in the combo boxes and it isn't working


Disabling several combo boxes based on a combo box
I've googled this to death and I can't quite figure it out. I am new to Access and this is my first time trying to figure out any Visual Basic code.

So I have one combo box called "TreatmentStage" based on a table: Column 1 Column 2
E1 1
E2 2
E3 3

When the "TreatmentStage" box reads, for example, "E1" I would like to disable combo boxes numbers 43, 46, and 50. (Or if not to disable, then to set these combo boxes to "sample_not_taken".)


concatenated textbox value based on combo box selections
I have a form with 3 combo boxes that have several options. On that same form, I have a textbox that I would like to autofill with the selected options from the combo boxes.

For example:
cbo1Options: 1;2;3
cbo2Options: a;b;c
cbo3Options: A;B;C

Let's say the user selects 2, c, and A from the 3 combo boxes. I would like the textbox on that form to display: "2 c A".

I tried doing a query, but that just autofilled the textbox with ALL the options available in the combo boxes, not the selected ones.


concatenated textbox value based on combo box selections
I have a form with 3 combo boxes that have several options. On that same form, I have a textbox that I would like to autofill with the selected options from the combo boxes.

For example:
cbo1Options: 1;2;3
cbo2Options: a;b;c
cbo3Options: A;B;C

Let's say the user selects 2, c, and A from the 3 combo boxes. I would like the textbox on that form to display: "2 c A".

I tried doing a query, but that just autofilled the textbox with ALL the options available in the combo boxes, not the selected ones.


Combo box in tbl...good idea or horrible?
I have a db that I am revamping. My question is more along the lines of proper development procedures.

Generally speaking, is it better to include combo boxes programmatically in the tbl or should all combo boxes be incorporated in frms only?

Does having a combo box in a tbl cause problems in the future?

Explanation: suppose 2 tbls:

tblPERSONNEL
-Employee# (pk)
-LName
-FName
-EquipmentTypeID (fk)

tblEQUIPMENT
-EquipmentTypeID (pk)
-Name
-Description

When looking in tblPERSONNEL, is it better for EquipmentTypeID to simply be a text box? Right now it is a combo box:

Bound Column: 1
Row Source: SELECT tblEQUIPMENT.Equip .
Column Count: 2
Column Width: 0";1"
etc, etc, etc

Please let me know how you do things. If I should do it a different way.now is the time to make the changes


Combo box problem
I have some combo boxes that do not display when prompted. Everything is blank, but the information is there if I click in the blank region. Also if I type the item in the combo responds that it is not on the list. These same combo boxes work on my desktop with access 2000. My laptop has access 2003. What is the fix?


Putting three list boxes once selected into one column
I have a MS Access 2003 database with several tables, queries, forms etc. My question is I have a simple form which has 5 boxes on it listing information from tables and queries. One of the boxes is linked to a lookup where I can get it to display three values but once the user selects which one they want it only displays the first value.

I want it to display all three under the one column so to speak. The Lookup lists Order, Forenames and Surname but only lists the Order when selected.

Is there any way I can get three values under the one column rather than having to put three boxes with three lookup's and then the user having todo it three times to get the information?


Recording Data from Snychronised Combo Boxes
me with this. I have a form with fields bound to a table and this is OK However I have two Combo boxes which are synchrosied from two seperate tables this works great. But, when I save the record the data from the two combo boxes disappears.

I know it is that the Combo boxes are not bound to the table and if you do bind them the combo boxes fail to work.

So my question is: How can I record the data selected within the combo boxes to another table without stopping the synchronisation between them


Autofill only working with first column, why?
I've used the "after update" event of a combo box to autofill other text boxes in the form. I found a supposedly simple method which goes like this:

Give the row source of the combo box several columns (the first being the combo box options and the others being fields that will auto fill the text boxes in the form)

In "after update" event write a code that is something like this:

Me.LICENCEDESCRIPTION = Me.TitleRef.Column(1)
Me.Address = Me.TitleRef.Column(2)
Me.AccessNotes = Me.TitleRef.Column(3)

The problem is that the column 2 and 3 never return anything. If I change column of all the auto fills to column 1, they all work. Likewise if I swap the columns in the row source around the information in column 1 still works.

So the content is there, the names are correct, but nothing is returned for columns 2 and 3?!

This is a little frustrating, surely there must be an easy fix.