combo box, search by second column but select value of first
However, when a row is selected from the combo box results the ID value is captured.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
How can I select the entire row so that I can use the Column(0,Combo.listindex) value?
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
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?
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
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
what I'm after is after combo box which will give me value for each Customer in a specific posting Date month
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
If Not IsNull(Me.cboItem) Then
strWhere = strWhere & "([Transaction Item] Like ""*" & Me.cboItem & "*"") AND "
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
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
SELECT Controls.Template_Name, Controls.Field_Name
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