i'm sorry to keep bothering you, but i have tried all day and can't get it to work. The error i get now is run time error 13 type mismatch. It highlights the else line. It does work if i only enter the last name. If i enter both it errors. These are all text fields so i'm not sure where there...
I have a table that has 2 fields lastname and firstname. I would like to be able to type on a form a firstname and lastname and be able to locate the matching records.
For example on a form type in smith and john and return all records that match, or just smith and leave the other blank and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.