I am writing a program using a MS Office Database and a visual basics program to run it. What I am trying to do is to have the students write in the name of a student that they want, and have the program post the E mail name for that student. The name of the database is "student" the field that I am searching is called "Name", and the code that I am trying to use looks like:

Data1.RecordSource = "Select * from students where Name = txtname.text "
Data1.Refresh

txtname.text is the text box where I want the students to write the name of the student that they are looking for. If you can help it would be greatly appriciated. Thanks.