query question

[Lauren B]

I have three fields: first name, last name, and middle initial. I am
creating a query for the user to search by client name. I have created a
drop down box on a form that displays these three fields; however, I have it
set up so they display: last name, first name, middle initial.

I used the following row source:
SELECT USERS.USER_ID, [LASTNAME] & ", " & [FIRSTNAME] & " " & [MI] & "." AS
FullName FROM USERS ORDER BY [LASTNAME] & "," & [FIRSTNAME] & "," & [MI] &
".";

I now want to use this as an input for a query. How can I write my query so
it will take this format as an input?

Thank you in advance for any assistance.

LB

 

[Guest]

Save the rowsource as a query (qryIdName).

Now you can write another query like

Select USER_ID, FullName from qryIdName

Chris

 

[Peter Kaufman]

I think Chris's solution would work also, but I am not so sure it is
necessary.

The combo box should have two fields: the first is the identity field
of the user, the second the full name. When a selection is made, you
simply pass the identity field to your query. You don't have to mess
with the actual names anymore - or am I missing something?

Peter