I have 3 more questions for you regarding your solution.

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

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

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

2. Im not sure If I understand your last line of code, what is the Cln
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 th
record and display them in my form, correct?

Thanks again, Im working on trying your code right now

--
Mcastee
-----------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...fo&userid=1569
View this thread: http://www.excelforum.com/showthread.php?threadid=27247