Search function using 2 textboxes on a form

S

sike11

Hello ppl,

I have a form which has 2 textboxes and a command button :

txtSurname, txtForename and cmdFindStudent.

I need for the user to input part or all of the student's first and last
names in the textboxes and return the fullnames once the command button is
clicked.

Eg:
Surname: ac*
Lastname: li*

Hit the command button and the first record corresponding to both text boxes
are filled.

Surname: Achom Lastname: Lilian

then carry on with the rest of the form.

Is this possible?
 
Top