Hi

I have a combo box in a search form. What I wanted to do is keep a record of
search items in a value list. It works okay until I entered a search for
"richard, lo".

The combo returns with a not in list message, and in the value list is
richard and lo. At debugging, I realised that the text in the combo box is
only "richard". I think it automatically split the text to 'richard' and
'lo'.

I want the value list to store "richard, lo". How do I overcome this issue.

Many thanks in advance for your help.

Richard

Hi, im just guessing here as not an expert, but have you tried concantenating
in a query and then basing the combo on the query.

=[firstname] & " , " & [surname]

this may work for you although i have not tried it.

regards

richard harris

"Richard" wrote:

> Hi
>
> I have a combo box in a search form. What I wanted to do is keep a record of
> search items in a value list. It works okay until I entered a search for
> "richard, lo".
>
> The combo returns with a not in list message, and in the value list is
> richard and lo. At debugging, I realised that the text in the combo box is
> only "richard". I think it automatically split the text to 'richard' and
> 'lo'.
>
> I want the value list to store "richard, lo". How do I overcome this issue.
>
> Many thanks in advance for your help.
>
> Richard
>
>
>
>