Topics Search

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

combo box, search by second column but select value of first
Views: 124
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:

Similar posts...

 

Select an item from a multi column combo box programmatically

Select an item from a multi column combo box programmatically Icon
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?
 

Using a lookup column as row source

Using a lookup column as row source Icon
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?
 

sum combo box based on other combo box

sum combo box based on other combo box Icon
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
 

Can not select item ny keyboard in combo box

Can not select item ny keyboard in combo box Icon
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

Using a Multi Select Combo Box and Query Out a single value from  that column Icon
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
 

Lookup multiple columns in combo box

Lookup multiple columns in combo box Icon
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?
 

Get columns from a multi column combo box

Get columns from a multi column combo box Icon
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?
 

Using combo box value as part of a query which is a report source?

Using combo box value as part of a query which is a report source? Icon
I have created a query which is the source of a report. The WHERE clause in the query is a value in the combo box, given as Combo.Text. The combo box's source is a column from a table and I'm not storing this value anywhere and had used the "Remember this value for future use" option which is provided when creating the combo box.

When I select an option from the combo box, instead of opening the custom report, a popup which says prompts me for the parameter opens, and when I type the value, it generates the report, but I want it to generate it on the click of the button after I select the option from the combo box. How can I do this?

The query is as follows:
 

Having problems with Combo Box (Form Control)

Having problems with Combo Box (Form Control) Icon
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.
 

auto populate text box based on combo box value

auto populate text box based on combo box value Icon
I would like to set up the following to auto populate the fields below based on the value I select in the combo box:

Rep field = combo box (LURequestor) with info included pertaining to the rep

The combo box row/source type is Table/Query; row source is SELECT qryReps.FullName, qryReps.[Last Name], qryReps.[First Name], qryReps.RegionNumber, qryReps.Region, qryReps.Division,
qryReps.[RSM-Director] FROM qryReps ORDER BY qryReps.FullName; & RepID is hidden

Region Number = unbound text box (Column 4)
Region = unbound text box (Column 5)
Manager = unbound text box (Column 7)
Division = unbound text box (Column 6)

I have tried setting up the text boxes with =[LURequestor].[Column](4) in
each unbound text box with the respective column number but the form shows "#Name?" in the field.