Another Combobox filter

[Guest]

How can I get this statement to only save the pID value in the field that the
combobox points to:

SELECT [persons.ptitle] & " " & [persons.pname] & " " & [persons.pSurname],
Persons.pID AS Expr1 FROM Persons;

This query is in the combobox's "Row Source".

 

[Rick Brandt]

How can I get this statement to only save the pID value in the field that the
combobox points to:

SELECT [persons.ptitle] & " " & [persons.pname] & " " & [persons.pSurname],
Persons.pID AS Expr1 FROM Persons;

This query is in the combobox's "Row Source".

I don't understand the question. A SELECT query doesn't "save" anything. Did
you leave out the statement you were asking about?

 

[Guest]

Ok, let me put it differently, I need the combobox list to SHOW this:

ptitle, pname and pSurname

and when you select one of the items in the list, the query has to SELECT
only the pID, which is to be placed in the combobox's value, but stil the
user only sees ptitle, pname and pSurname. I don't know what I am supposed
to call these things, I hope you understand now.

How can I get this statement to only save the pID value in the field that the
combobox points to:

SELECT [persons.ptitle] & " " & [persons.pname] & " " & [persons.pSurname],
Persons.pID AS Expr1 FROM Persons;

This query is in the combobox's "Row Source".

I don't understand the question. A SELECT query doesn't "save" anything. Did
you leave out the statement you were asking about?