M
Mcasteel
Im trying to look up a specific SSN from Column F. The End-User wil
input a Customer SSN that they are looking for into a text bo
(txtCustSSN).
If the SSN is found, I want to return the customers Lname, Fname
Info1, and Info2 back to my customized form. If the SSN is not found
want to return msgbox "Customer Data not Found".
_Data:_
Column A = Date
Column B = Type
Column C = Lname
Column D = Fname
Column E = Mname
Column F = SSN
Column G = Info1
Column H = Info2
ANY IDEAS ON HOW TO SEARCH A COLUMN OF OR 300+ SSN'S TO \"MATCH\" TH
SSN THAT THE END-USER INPUTS INTO THE TEXT BOX TXTCUSTSSN
Ive been having a really hard time with this, please respond with a
much info as you can.
Thank you
input a Customer SSN that they are looking for into a text bo
(txtCustSSN).
If the SSN is found, I want to return the customers Lname, Fname
Info1, and Info2 back to my customized form. If the SSN is not found
want to return msgbox "Customer Data not Found".
_Data:_
Column A = Date
Column B = Type
Column C = Lname
Column D = Fname
Column E = Mname
Column F = SSN
Column G = Info1
Column H = Info2
ANY IDEAS ON HOW TO SEARCH A COLUMN OF OR 300+ SSN'S TO \"MATCH\" TH
SSN THAT THE END-USER INPUTS INTO THE TEXT BOX TXTCUSTSSN
Ive been having a really hard time with this, please respond with a
much info as you can.
Thank you