Referencing a calculated column of a query/combobox

  • Thread starter Thread starter Jeff Klein
  • Start date Start date
J

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
 
Try strClientFullName=ClientFullName.Column(1)
Access counts columns starting at zero, so Column(0) would be the ID number
 
Works great. Thank you very much, Jeff

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

Jeff Klein said:
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
Click to expand...
Click to expand...
 
Back
Top