On Thu, 27 May 2010 22:07:01 -0700, forest8
wrote:

Hi there

I made tje suggested change and I now see both the first name and last name
in the search.

But I have two questions:

1. The names aren't alphabetically. Is it possible to have the names sorted
by their first name?

Follow the instructions that I posted; they will sort by first name. In the
query grid there's a row for sort order; select Ascending under firstname (and
put Lastname to the right of Firstname and sort by it too).

2. I'm not very good with code. So how should I write the AfterUpdate Event
procedure so that it actually goes to the correct record?

That is what the combo box toolbox wizard does for you without your even
needing to SEE the code. Since I don't know anything about your table names,
fieldnames, form name, control names, etc. I can't write your code for you.
--

John W. Vinson [MVP]