Listbox Value

[StephanieH]

This has to be easier than I'm making it. I have two Listboxes on a form. I
want to combine the input from the listboxes to create a single value. For
instance if the value from Listbox2 is "2005" and Listbox3 is "03" I want my
value to be "2005_03". I've tried MyValue = " & ListBox2.Value & "_" &
Listbox3.Value & " and MyValue = ListBox2.Value "_" Listbox3.Value and
neither work. What am I doing wrong?

[Dave Peterson]

MyValue = ListBox2.Value & "_" & Listbox3.Value

Didn't work?

StephanieH wrote:
>
> This has to be easier than I'm making it. I have two Listboxes on a form. I
> want to combine the input from the listboxes to create a single value. For
> instance if the value from Listbox2 is "2005" and Listbox3 is "03" I want my
> value to be "2005_03". I've tried MyValue = " & ListBox2.Value & "_" &
> Listbox3.Value & " and MyValue = ListBox2.Value "_" Listbox3.Value and
> neither work. What am I doing wrong?

--

Dave Peterson

[StephanieH]

Ugh. So close, and yet so far.

Thanks Dave.



"Dave Peterson" wrote:

> MyValue = ListBox2.Value & "_" & Listbox3.Value
>
> Didn't work?
>
> StephanieH wrote:
> >
> > This has to be easier than I'm making it. I have two Listboxes on a form. I
> > want to combine the input from the listboxes to create a single value. For
> > instance if the value from Listbox2 is "2005" and Listbox3 is "03" I want my
> > value to be "2005_03". I've tried MyValue = " & ListBox2.Value & "_" &
> > Listbox3.Value & " and MyValue = ListBox2.Value "_" Listbox3.Value and
> > neither work. What am I doing wrong?
>
> --
>
> Dave Peterson
>