Re: Combobox help

It's not clear what you want here. Do you want all three options to show as
values in each row? Or do you want to show the three "options" exactly as
you've posted (which I admit would not seem to make sense)? Or do you want
the ability to let the user select which option to show? Or do you want a
single value to show that will not have "blank or extra spaces" if a value
doesn't exist in one or more of the fields?

--

Ken Snell
<MS ACCESS MVP>

"Sue Compelling" <SueCompelling@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5290B019-BF6C-416B-A634-E854D4904397@xxxxxxxxxxxxxxxx
> Hi - really stuck on this one - a newbie and can 'do code' if everything
> is
> supplied.
>
> I want the following THREE options to be available from the combobox [and
> am
> assuming that it can be done]
>
> CG1FirstName & " " & CG1LastName & " & " & CG2FirstName & " " &
> CG2LastName
>
> or
>
> CG1FirstName & " " & CG1LastName
>
> or
>
> CG2FirstName & " " & CG2LastName
>
> TIA
> --
> Sue Compelling


.