combo box issue

[Richard]

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

 

[Guest]

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