Show multiple columns from a drop-down list

I have a column in a table that is populated by a drop-down list / look-up table. The look-up table has 3 columns - autonumber, ID ref, and name. I need the column in the main table to show the contents of the ID ref and name column.

Is this possible? At the moment, when I click into the main column, the drop-down list shows the contents of the two columns (ID ref & name), but when I choose from the list, it only shows the contents of the ID ref.

If it isn't possible, can I change it so both columns are shown in the drop-down, but the contents of the name column are displayed in the table.

Sponsored Links:

Related Topics

Use arrow key in drop-down list
I have a form with multiple drop-down lists. Currently, when I go to each field, I still to use the mouse to click the "inverted triangle" to show the options in the list. I would like to just use the the arrow down key (instead of the mouse) to show the list. How do I go about that?


Reports and changing the names
I am using Access 2010. I used a template called calltracker from Microsoft. I have adapted it to my use. Instead of tracking calls it is tracking follow ups. On one form there is a drop down list of reports that came with the template. I have modified the reports structure to fit my needs but in the drop down list they still show the names that came with the template. How can I change the names of the reports that show in the drop down list. How can I add additional reports I created to show in this drop down list


Sending multiple selections from a 'drop down' list in a Form to an append query
In Access I have a form with a drop-down list. I have set the form to 'multiple select' so I can select more than 1 item at once. At the end of the form is a button that runs an append query.

How do I get an 'append query' to insert all the items I have selected? If I have a drop-down that only allows me to select 1 item it works fine, but when doing multiple selections it just returns a blank. Screenshot below to show multiple selection.


Issue with query when selecting from a drop-down list on a form
I have created a form in Access where the user selects a name from a drop-down list. The list has been derived from a table that already exists in Access. The form then executes a query to only show records that match the selection made from the drop-down list.

The problem that I have is it returns no records. If I change the drop-down list to a standard text box and type the name in manually, it brings back the records I want.

Why is my drop-down list not working? The query that is being run uses the table that contains the names so it can't be anything to do with additional spaces etc.


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


Lookup wizard/drop down list problem
I can't get the lookup wizard/drop down list to work properly. I have two fields that need a drop down list. the first works - it shows two columns, name and account; and populates the field with the account.

the second doesn't work - it shows two columns, name and item number; and populates the field with the name. what am I overlooking that is making it use the nameinstead of the account?


updating a drop down list
I have a form where you pick a course name from a drop down list. Next to it I created a button that opens for a form with courses names where you can add a new one. Then I save the new course name and close the form.

The thing is - the new name doesn't show on the original drop down list until I reopen the form. Is it possible to do something that it actually appearsstraight away?


updating a drop down list
I have a form where you pick a course name from a drop down list. Next to it I created a button that opens for a form with courses names where you can add a new one. Then I save the new course name and close the form. The thing is - the new name doesn't show on the original drop down list until I reopen the form. Is it possible to do something that it actually appears straight away


Get multiple columns with same value
I've got multiple columns for the CFName on each tbl. My question is how can I create a query which will list all the customers with supplier id SP102.


Sorting Columns in a Microsoft Access Listbox
When using a Microsoft Access Listbox, there may be times when the list is long and the data in this list is not sorted as you would like.
Obviously the list can be sorted in the first case, by basing the list on a query or SQL row source and setting a sort order on one of the columns in Ascending or Descending order. This list may, however, contain multiple columns that the user may wish to sort on and this is what we will describe in this article.


Trying to sort data into multiple columns on the report.
Access 2007 I have 1 data column that I want to get on a report, but I want it to break into two/three columns like so and have some space inbetween the columns:

1 | 7 | 13
2 | 8 | 14
3 | 9 | 15
4 | 10 | 16
5 | 11 | 17
6 | 12 | 18

The reason is this is a single checklist for people to fill out and multiple pages is unacceptable. The list will be printed.


Table drop down list help
I need help with a database that I am setting up that will be uploaded to sharepoint. This is an access 2007 db. In my database I have the following tables (no forms/reports/or queries except for queries nested in the tables):

My problem is with the setting up the time reporting table. In the time reporting table I have the following columns:
AccountID [Drop down list - lookup from accounts table, ProjectID lookup from projects], Employee, etc.

I need to find a way to set it up so that when a user goes to report time:

And selects an accountID from the drop down list, when they click on the projects drop down list, they only see projects for the account that they have selected.


Question about Value List
I have a drop down list control on a form, and in the Properties Sheet, under Row Source Type, it says "Value List."

The Row Source is as follows: "Stat";"Statistics";"Demo";"Demographics" and so on.

When I run this form in Form View, I notice that there are two columns. However I don't see where one can modify the number of columns in the Properpty Sheet.

Question: Does the Value List use 2 columns by defaults? Is there a way to change this?


Show / Hide Datasheet Columns in a Subform
I've got a main form with two lists boxes. I want to show the visible columns in my subform (which is a datasheet) in one listbox and show the hidden columns in the other. Also I want to allow the user to hide / show columns using right or left arrow buttons between the list boxes. My subform is bound to a stored procedure using ADO.


Populate the selected data from sub form to drop down list
How can I populate the selected data from sub form to the drop down list? My sub form has 5 columns and only column 1 data of selected record will be populated in the drop down list. How can I do that and what VBA code I should use


Contact list in Sharepoint 2010
Here is what I am trying to do.I need to create a form for a contact list that has several drop down boxes containing the contact names. Simple enough.

Here is where I have a problem:
This form must have 15 drop down boxes containing 15 names and I need for that contact list in the drop down box to rotate. Meaning, that when a user goes in to the sharepoint site and creates a new entry they are presented with the dropdown box with names in it.

When they select a name I need for the next drop down box to show up with the next name in line. So it would be something like this:


Filter form on drop down box selection on button click
I have a form and I need to be able to filter it from the selection of a drop down list on the form. I don't what it to filter automatically once a selection is made from the list but I need it to filter on button press using the selection from the list and to only show records that include the value selected from the list.

I'm ok linking queries to filter forms linked to a button but having problems understanding how I tell the query to take the value from the selection in the drop down list.


List spread over three columns
Does anyone know how to split a report list of records over three columns in each page, from left to right?

I have a single field list of over 1,000 entries that I want to present in three columns, thus greatly reducing pages used.


Table drop down list filter
I am setting up a Access 2007 table that will be uploaded to sharepoint. In my database I have the following tables (no forms/reports/or queries except for queries nested in the tables):

Employees, Accounts, Projects
NOTE: in the Projects table I have an Accounts column which is has a one to many relation with the accounts table, and it's doing a lookup from the accounts table
Time Reporting

My problem is with the setting up the time reporting table. In the time reporting table I have the following columns:
AccountID [Drop down list - lookup from accounts table, ProjectID lookup from projects], Employee, etc.

I need to find a way to set it up so that when a user goes to report time:
And selects an accountID from the drop down list, when they click on the projects drop down list, they only see projects for the account that they have selected.


Return the value of Multiselection dropdown list (VB)
I have a drop down list that has "other" as a choice and I have a text field called "if other, plz specify" next to it which is invisible.

I want to check if "other" is one of the items selected from the drop down list is "other".
when I'm using single selection drop down list the following code works:

Private Sub dropdownlist_AfterUpdate()
If (Me.dropdownlist = "Other") Then
Me.If_other__please_specify.Visible = true
Else
Me.If_other__please_specify.Visible = false
End If
End Sub

how to write the same condition ,but for multiselection drop down list ?