combo box, search by second column but select value of first

I have a combo box that offers about 100 rows from which a user must choose a value. Two columns are displayed - ID, Friendly_name. The combo box is bound to the ID (1st) column. To make it easier for users I wanted them to be able to type the friendly name and have the combo box scroll to the nearest match, like an autocomplete field.

However, when a row is selected from the combo box results the ID value is captured.

Sponsored Links:

Related Topics

Select an item from a multi column combo box programmatically
I try to select a value from a multi column combo box programmatically. When you do that with VB6 you just set the listindex property to the desired row (minus 1). The fact is that in access you can't do that because this property is read only. I googled on that and I found that you can set the combo box to Me.Combo = Me.combo.column(1, DesiredIndex). This does the trick but I believe it just sets the text property of the combo box and doesn't select the row.

How can I select the entire row so that I can use the Column(0,Combo.listindex) value?


Combo box wont accept input
I have created a search form with a combo box to let users find a specific name, this works OK (Click the arrow and names appear in the list, great) but, when a name is chosen the combo box remains blank and an error beep is heard (I believe the beep is just a default sound when something isnt right)

Combo Box settings;
Control Source - CliID
Row Source - SELECT Clients.CliID, [CliFirstName] & " " & [CliLastName] FROM Clients;
Column Count - 2
Bound Column - 1
Column Widths - 0,2.45


Filter by combo box & text box?
If you select forms and then click "frmResults". The click the search button. When I select Name from the combo box and enter a name it will return any record with that name. My problem is with the telephone number. I need to be able to select "Telephone" from the combo box and enter a telephone number into the text box. When I select search the query should search all 3 telephone fields in the master table. (Daytime, Evening and mobile) I think I need a LIKE or statement but cant get it working


Using a lookup column as row source
I'm trying to set up a combo box that will search my records and I've gotten it to work, however I'm trying to fix the values it displays.

The row source for the combo box is

SELECT [Match].[MatchID], [Match].[Home], [Match].[Away] FROM [Match];
, with the fields Home and Away being lookup fields themselves, with rowsources
SELECT [Team].[TeamID], [Team].[TeamName] FROM Team;

So the search combo box displays MatchID, Home and Away fine, but it shows the TeamID column of Home and Away, and I would like it to show the TeamName column. Is there a way to use the column function (I.e. Column(#)) in the row source?


Select field you want to search, select value, then Search
The goal of my project is to create 2 combo boxes and one "button" that enables the user to search my database.

The first combo box (called FieldCBO) lists the field names: Eg. "Last Name, First Name, Address" fields from the "CONTACTS" table.

The second combo box (called ValueCBO) is bounded to the first combo box so that if you select the "Last Name" field, everyone's last name will show up (e.g. Smith, Doe, etc), if you select the "First Name" field, everyone's first names will show up (e.g. John, Jane, etc).

Unfortunately, I can't get this second combo box. I believe something is wrong with my "Row Source: SELECT Forms![Search Form]!FieldCBO FROM CONTACTS" because an error message stating "The Access database engine does not recognize 'Forms![Search Form]!FieldCBO' as a valid field name or expression

What should I put in place of "Forms![Search Form]!FieldCBO


combo box query search
I'm trying to create a form which has 2 combo boxes. The second combo box depends on what happens on the first e.g. food on the first on then the food names will show up on the second

I've managed to get this working but I would like to add a search button so it will check the first combo box and go to that field title in the database then the second combo box will determine the results e.g.

If I chose food in the first combo box then chose pizza in the second one it would go to the food column and only show pizza within it


sum combo box based on other combo box
I have two combo box which are Customer Number and Period Posting Date coming from the same table,
what I'm after is after combo box which will give me value for each Customer in a specific posting Date month

for example

if some select Customer Number 0001 in combo box 1
and then select 2009/07 in Combo box 2
I want combo 3 or a text box to sum the values in thee amount column and display the total in combo 3 or they text box


Using Combo box in search form
So I've managed to use a search form that was posted on here but I am having a problem being able to search based on the displayed results of a combo box. I am trying to have a field search the second column of the combo box but I don't know the code to do so. To simplify the question here, is there a way I can use the search function that I built to find only the results based in column two (the displayed field on the search form) here is the code I am currently using:

'Item Search.
If Not IsNull(Me.cboItem) Then
strWhere = strWhere & "([Transaction Item] Like ""*" & Me.cboItem & "*"") AND "
End If

Right now all it lets me do is search but the first column the primary key Inventory.ID and not what I need Inventory.Item


Enter search text into Combo Box and return results from Query into same Combo Box
I want to have an "instant search" in a form that I have. I have a working model of this that is the setup shown on this <a href=""http://www.access-programmers.co.uk/forums/showthread.php?t=188663"">site</a>

The problem is that I want to make it better, what that means is that I want to be able to enter my search text into my combo box and have it run my query on change and produce my results in the combo box dropdown. I am not tied to this idea but I would like to see if its possible.

My table contains two columns that I want values from in my results.

Table Name = Controls
Column 1 = Field_Name
Column 2 = Template_Name

qryControls =
SELECT Controls.Template_Name, Controls.Field_Name
FROM Controls
WHERE (((Controls.Field_Name) Like "*" & [Forms]![Dummy Form]![txtSearch] & "*"))
ORDER BY Controls.Field_Name;

Is there any way to do this? I have tried countless efforts and cannot get it to work properly


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).


Combo box to search multiple columns on one record
I am working on a project and need some help.

I have records that could have a date in column 1-15. I need to be able to put in a date, or select if from a combo box. If that date is in any one of the columns, I need it to display the record along with all the other data.

ID Name Date 1 Date 2 Date 4 Date 5
A Bob 2/12/11 3/12/12 4/12/13 5/12/14
B Fred 5/12/14 6/12/15
C Jo 2/13/11 3/12/12
D Sue 6/12/13 5/12/14

If I select 5/12/14 in the combo box I would expect to get record A, B and D along with their data.


Lookup multiple columns in combo box
Is there a way to lookup information ina bound combo box based on either columns.

Here is a scenario I have a bound combobox with two columns Column(0), and Column(1) both visible. I want to search the combobox based on either value of both columns. In the words if Isearch ID it will lookup the value and if I search by name it will also lookup names.

Is there a sample VB script in the after update event of combo box that will accomplish that?


Text box query to subform with combo box
I have a form with a text box set to be used as a search box. The search should return data associated with that particular data item in a subform. The same subform has a combo box set up to display two columns of data for that searched data. All data is in one table. The search form now displays the first record and would cycle through the records with navigation. The combo box displays all data for the two required columns. What I need is to get the text box search to select the related data into the subform and combobox. I have a hidden combobox in the main form that the text box should retrieve the tables data to select the correct record(s). It holds the tables entire content. How can I upload the file


Can not select item ny keyboard in combo box
I have a form with a combo box to select the customer.

Row Source: table (linked from another MDB)
Column count: 2 (fields code and name, both text fields)
Bound column: 1 (code field)
Limit to list: yes
Expand: Yed
Format: none

Tested in Access 2003 and Access 2007

Issue: I can select items expanding the combo box and selecting the item with the mouse, but if I write in the combo box and then pulse intro MS-Access shows the known error message ". you must select an item of the list.". Also, filtering of the combo box does not work

If I delete the combo box and put another one with the same values it works until I close MS-Access. Once I go intro again it shows the same problem

If I relink all tables it works until I close MS-Access. Once I go intro againg it shows the same problem


Using a Multi Select Combo Box and Query Out a single value from that column
I have a Project Form, from that Form the user is able to multi select employees in a combo box. Meaning there could be multiple employees for every project. Example: John Smith; John Jones; Stephanie Johnson. I am using a form that uses cascading combo boxes for when the employee combo box is populated. example John Jones. Then the Project combo box will automatically fill with only John Jones' Projects.

So I need a way for on the after update action. I would be able to pull one value from the employee column in the Project Form. The code I am using currently worked before the employee column on the Projects form was changed to a multi select the code I was using is below


Combo Box Unique Value Error on Tab
I created a form and in the form I placed a combo box. I set the row source to a query built of a single table. Bound Column =1. Column Count=5. Column Widths = 0",1", 1", 1", 1". List Wdth=4". Column main.id, main.search, main.c_name, main_add1, main_state.

In Form view I select the record I'm looking for and tab. After tab I get an error stating "Changes to the table was not successful because it would create duplicate records


Query Critieria using Combo Box Column
From what I understand, I can't use a different column other than the first to filter query criteria. To get around this I made the first column the search criteria I need and then hide it by putting the column width to zero.

It is using VBA to add the column amount to a variable and then filtering the search criteria by that variable.


Get columns from a multi column combo box
I am developing a web database. I have a combo box for which I have a query:

select id, value from table

I have number of columns = 2, Now in a macro. I want to extract the id [I think Id is column 1] from the combo.If I try:

[Forms]![frmAdmin]![cboProduct]!Columns(1)

But this is not valid. How do I just get ID of the selected value?


Having problems with Combo Box (Form Control)
I have created several combo boxes which all have the same prefix in the name of the table: CB.

For instance, in the CB YNDK, there are two columns. The first is the ID, and the second is a column with the following: Yes, No, Don't Know.

Until recently, when I use the combo box (Form control) button, I am not able to choose the CB table I want to use but it creates a combo box which attached to the CB by checking the Table/Query data.

I then have to change the Column Count to 2 and change the Column Widths to 0. And sometimes this change doesn't happen and I have to keep playing with
the settings.

1) what's going on with the Combo box (Form control)? Why can't I select
which CB Table I want to use; and

2) What's going on with the column count and column widths settings?

I haven't made any changes (I.e. updates) to my Access 2007.


Submit form values into a table (with requirements).
wondering if you guys can help me.

I have a form with two combo boxes and a checkbox. The first combo box is to select and Job Number, the second is to select an employee name based on the job number.

I need the form to be able to (on submit) place the values of the two combo boxes into a table (Data) under the relevant columns, for example the first combo box to go under Job Number column, the second to go under Employee Name column. But I need them to update as most of the time the values will already be in the table.

The third value (the combo box) is a bit more tricky. If the checkbox is ticked I need it to stamp the value thats in the first combo box (the Job Number) into a generated column based on the date.

If anyone has any idea how to do this or any help you can give me would be