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!
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,704
Office Version
  1. 2016
Platform
  1. 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).
 

Watch MrExcel Video

Forum statistics

Threads
1,133,565
Messages
5,659,569
Members
418,508
Latest member
deepakfer

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top