Access 2007 - combo box pull-down menus

ml20090412

New Member
Joined
Apr 12, 2009
Messages
25
I have a field called "ClientName" in one of the tables in my database. The data in this field is a combo box containing two fields from another table: one field is called "FirstName", the other "LastName". The fields are ordered "FirstName" then "LastName" in the combo box.

When I'm in datasheet view, if I go to the field "ClientName" and type in "John", the pull-down menu will move automatically to a record with the first name "John", as long as there is someone in the source field with this first name. However, if I try to type in a last name such as "Smith" -- even if there is someone in the source field with this surname -- Access gives me the error message,

"The data you entered isn't an item in the list"

The same occurs if I type in the full name "John Smith".

Is there a way to search quickly through any of the fields contained in a combo box pull-down menu? (Or by any combination of these fields?)

If it helps, here is the rowsource for the combobox:

Code:
SELECT [Basic client data].[ClientID], [Basic client data].[FirstName], [Basic client data].[LastName] FROM [Basic client data] ORDER BY [FirstName], [LastName], [ClientID];
Thanks!
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,658
Office Version
2016
Platform
Windows
Have you tried using wild characters or Like when looking for surnames?

*Smith

Like Smi*

Help will give you some basic suggestions on wild characters
 

ml20090412

New Member
Joined
Apr 12, 2009
Messages
25
Have you tried using wild characters or Like when looking for surnames?

*Smith

Like Smi*

Help will give you some basic suggestions on wild characters
I tried * and the Like command, but got the same error message in both cases: "The text you entered isn't an item in the list". The pull-down menu only seems to recognize the first field of the combo box (= FirstName).
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,404
Messages
5,511,156
Members
408,828
Latest member
Csmnvld

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top