I have a userform set up for data entry, I would like a number of textboxes to autofill from a database depending on if the surname matches to an existing client.
For example, if Smith was entered in the Name field, his address, phone no, email, etc would automatically appear in the relevant textboxes from the client database. If no match all fields would remain empty (the inputted info doesn't go into the database unless you click on a checkbox).
I've tried VLOOKUP's, variables, etc, any help please.
For example, if Smith was entered in the Name field, his address, phone no, email, etc would automatically appear in the relevant textboxes from the client database. If no match all fields would remain empty (the inputted info doesn't go into the database unless you click on a checkbox).
I've tried VLOOKUP's, variables, etc, any help please.