Referencing a calculated column of a query/combobox

[Jeff Klein]

I have a combobox (ClientFullName) that has a rowsource :

SELECT DISTINCTROW Clients.ClientID, [ClientLastName] & ", " &
[ClientFirstName] AS ClientLastandFirst
FROM Clients;

The combobox "Value" is the clientID number.

Is there a way to reference the ClientLastandFirst value from this combo
box.

I have tried strClientFullName = ClientFullName.Value but Ill i get is the
ClientID number.

Any help is appreciated. Thanks Jeff

 

[Mark]

Try strClientFullName=ClientFullName.Column(1)
Access counts columns starting at zero, so Column(0) would be the ID number

 

[Jeff Klein]

Works great. Thank you very much, Jeff

Try strClientFullName=ClientFullName.Column(1)
Access counts columns starting at zero, so Column(0) would be the ID number

I have a combobox (ClientFullName) that has a rowsource :

SELECT DISTINCTROW Clients.ClientID, [ClientLastName] & ", " &
[ClientFirstName] AS ClientLastandFirst
FROM Clients;

The combobox "Value" is the clientID number.

Is there a way to reference the ClientLastandFirst value from this combo
box.

I have tried strClientFullName = ClientFullName.Value but Ill i get is the
ClientID number.

Any help is appreciated. Thanks Jeff