Kckronic21
Programmer
I am having a problem with getting my query to run through this form. I have an Advisor table with these fields: Advisor, Major, Phone Number, Section. The data in this table is displayed like this: Mr. Smith, Computer Technology, 586-3933, O-R. (This is a made up example) I also have a student form that was created by a student query that displays the information about the student. The student query has these fields: SSN, Last Name, First Name, Street Address, City, State, Zip, Phone Number, Major, Term, and Advisor. What I would like to do is after the user puts in the students major in the form, I want to run the Advisor Query so that it just displays the advisors in that particular major. I also wanted to know if there was a way to run a query that puts that correct advisor name in the form for the student after the user puts in the student’s last name and the student’s major in the form.
Thanks
Thanks