Just to add to Bob's response.

#1. It looked like you were using some sort of textbox to ask the user what
the SSN to retrieve.

That value in the textbox is text--so you have to make it match the values
(which are numbers formatted pretty) in your data--hence, the clng()
portion.

#2. see #1 <bg.

#3. Maybe <vbg.


Mcasteel wrote:

I have 3 more questions for you regarding your solution.

1. SSN
The SSN column is formatted as "Special" / Social Security Number in
the Excel file.

When viewing the SSN: it shows with dashes (123-45-6789) but if I pull
the value from Excel into the form as a string it displays with out the
dashes (123456789) which suites my needs.

After the above experiment Im assuming the ssn is just a string or text
and not a number.

2. Im not sure If I understand your last line of code, what is the Clng
used for?

iRow = whateveryouchose.match_(*CLNG*(_CustSSN), _
Worksheets("Sheet1").Range("f27:f307"), 0)

3. With this piece of code, I will be able to take values from the
record and display them in my form, correct?

Thanks again, Im working on trying your code right now.

--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698
View this thread: http://www.excelforum.com/showthread...hreadid=272475

--

Dave Peterson