Another Combobox filter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Archangel - 23 Nov 2006 11:54 GMT

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".

Reply to this Message

Rick Brandt - 23 Nov 2006 12:40 GMT

> How can I get this statement to only save the pID value in the field that the
> combobox points to:
[quoted text clipped - 3 lines]
>
> 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?

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Archangel - 24 Nov 2006 11:20 GMT

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

Reply to this Message