Selecting part of a comma separated field

[paulminne]

Hi,

I have a combo box which is populated with a concatenated expression from two fields in a table

(ie. expr 1: [Surname] & ", " & [FirstName]).

What I am trying to do is just select the Surname contents of the combo box and store it in a variable, and the FirstName contents and store them in another variable.

How is this done?

thanks in advance...

 

[Pampers]

Why store the Surname and Firstname again?
I suppose the combox is on a form, why ask the question in the query-section?

Pampers
Just let it go...

 

[lespaul]

Alternatively, add Surname and FirstName as separate fields to the Query that is the source of the Combobox and in the select event of the combobox, populate the variables with the values from the query.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design