I made a userform that will compile a list of deliquent customers, and put
them in a listbox. I wish to activate a Customer info form that'll display
the information of the customer that you click on from the listbox. I need
help with only one part of this. The listboxe has a 12 character phone number
before every item (ie - 254-254-2542 - James Patterson) I wish to perform the
search based off of the first 12 characters in the string (the phone number)
when I click on one of the items from the list. Can someone give me a clue as
to how to do this.

Just extract that part of the selected item,

Left(Listbox1.Value,12)

and use that in your search.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"tom" wrote in message
...
I made a userform that will compile a list of deliquent customers, and
put
them in a listbox. I wish to activate a Customer info form that'll display
the information of the customer that you click on from the listbox. I need
help with only one part of this. The listboxe has a 12 character phone
number
before every item (ie - 254-254-2542 - James Patterson) I wish to perform
the
search based off of the first 12 characters in the string (the phone
number)
when I click on one of the items from the list. Can someone give me a clue
as
to how to do this.

Thanks Bob. That was a big help. People like you, help my business run
better, and I am grateful. Happy New Year!
Tom

"Bob Phillips" wrote:

Just extract that part of the selected item,

Left(Listbox1.Value,12)

and use that in your search.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"tom" wrote in message
...
I made a userform that will compile a list of deliquent customers, and
put
them in a listbox. I wish to activate a Customer info form that'll display
the information of the customer that you click on from the listbox. I need
help with only one part of this. The listboxe has a 12 character phone
number
before every item (ie - 254-254-2542 - James Patterson) I wish to perform
the
search based off of the first 12 characters in the string (the phone
number)
when I click on one of the items from the list. Can someone give me a clue
as
to how to do this.