Hi there,
I am using a combo box with a control source consisting of a query of these fields:
Course
Faculty
Department
I have two textboxes called 'faculty' and 'department'. The way it should work is as follows:
The user selects a course from the dropdown list, the corresponding faculty and department go in their respective textboxes.
All of this data in aligned in a table called tbl_course and the query shows all of the necessary data in it.
Any ideas how this can be done?
I am using a combo box with a control source consisting of a query of these fields:
Course
Faculty
Department
I have two textboxes called 'faculty' and 'department'. The way it should work is as follows:
The user selects a course from the dropdown list, the corresponding faculty and department go in their respective textboxes.
All of this data in aligned in a table called tbl_course and the query shows all of the necessary data in it.
Any ideas how this can be done?