Search Form...if found return in listbox (1 Viewer)

[kate10123]

Hi there

I am trying to create a searchable form for users because the standard find and replace feature in access is not suitable.

I have three search options available to users:
Surname
First Name
Student Number

I have a text box called txtSearchTerm where the user can enter either a student surname, first name or student number depending on the option they have selected.

I have a command button called cmdSearch which I need to take the value entered in txtSearchTerm and search through table tbl_student for that record and display it in the listbox I have on screen called lstSearchResults.

I know the process but not sure how to write this in vb. Here is my english version of what I need:

If option1(surname) is selected search through surname column of tbl_student for txtSearchTerm value and display in lstSearchResults.
same applies for option2 and option3.

Any starting help appreciated!
Kate

 

[Luddite Lad]

Have a look at the search function in this thread, it might be what you are looking for.

 

[kate10123]

Thanks that worked great!