Teachert
  Home FAQ Contact Sign in
 
Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...

found 2 articles for 0.303 sec
your second combo box needs to have a filter attached on your first combo box add the vba code sub combobox1_afterupdate() combobox2.Rowsource = "Select TeacherID, TeacherName from TeacherTable Where [Grade] = '" & Me.Combo1 & "'" end sub placing that code will only update combobox2 when combobox1 has a value if you use fredgs example you have to use sub combobox1_afterupdate()     

Group: microsoft.public.access.queries · Group Profile · Search for Teachert in microsoft.public.access.queries
Author: Lord Kelvan
Date: Sep 18, 2008 21:19

On Thu, 18 Sep 2008 16:32:02 -0700, Tony wrote: I am creating a directory for our school and using two combo boxes in a form. The first tells the student's grade. The second combo box is supposed to use this information (K, 1, 2, 3, 4, or 5) and look up that grade in a table and list only the teachers for the grade selected in the second combo box. However, I cannot get the
Show full article (0.48Kb) · Show article thread
    

Group: microsoft.public.access.queries · Group Profile · Search for Teachert in microsoft.public.access.queries
Author: fredg
Date: Sep 18, 2008 17:14

Show full article (1.78Kb) · Show article thread