Data in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a table called student which contains details about students in a
university, also there is a table called college which has the details of all
the colleges and the departments and courses under each college.

i made a form on student table, what i want to do is that when a user
selects a value from the list box (having college names) then depending upon
his selection the list box for department should get populated, taking data
from the college table. and similarly when the user clicks on the depratment
value then the courses under that particular department should get populated.
 
Siddarth,
I have a dowloadable file on my web site (listed below) called "Synched
Combo Boxes" under Acess Tips. This shows how to use the value of Combo1 to
filter the contents of Combo2. It's in Access 97.
 
Back
Top