A
allan
I have table1 containing the following data which is loaded on a form
student id name address subjectid
professor profID profsubj profroom
0001 ABCD ADDR1 MATH101 Dr.
Jones J1
0001 ABCD ADDR1 MATH102 Dr. Ron R1
0002 XYZ ADDR2 MATH103 Dr. Smith
S1
0002 XYZ ADDR ENGLISH101 Dr.
Cymbal C1
0003 LIAN ADDR4 ENGLISH101 Dr.
Cymbal C1
0004 OSCAR ADDR5 MATH101 Dr.
Jones J1
I created another table bound to a form which will pull the data on table1
based on the value I passed on a text box. For some reason I need 2 input
parameters from table 1 to pull the student information (StudentID) and
Professor information(ProfID) to populate my new table.
I understand SQL and vba codes but being novice on access application I am
not usre how to put it all together. I will appreciate any help you can
provide.
student id name address subjectid
professor profID profsubj profroom
0001 ABCD ADDR1 MATH101 Dr.
Jones J1
0001 ABCD ADDR1 MATH102 Dr. Ron R1
0002 XYZ ADDR2 MATH103 Dr. Smith
S1
0002 XYZ ADDR ENGLISH101 Dr.
Cymbal C1
0003 LIAN ADDR4 ENGLISH101 Dr.
Cymbal C1
0004 OSCAR ADDR5 MATH101 Dr.
Jones J1
I created another table bound to a form which will pull the data on table1
based on the value I passed on a text box. For some reason I need 2 input
parameters from table 1 to pull the student information (StudentID) and
Professor information(ProfID) to populate my new table.
I understand SQL and vba codes but being novice on access application I am
not usre how to put it all together. I will appreciate any help you can
provide.