Another Combobox filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

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".
 
Archangel said:
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".
Click to expand...

I don't understand the question. A SELECT query doesn't "save" anything. Did
you leave out the statement you were asking about?
 
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.

Rick Brandt said:
Archangel said:
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".
Click to expand...

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