Details of subform based on combobox selection

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • katlego
    New Member
    • Mar 2010
    • 5

    #1

    Details of subform based on combobox selection

    I need assistance with displaying the records of a particular student based on the selection made in the combobox. I have query called students that displays all the records of the students. The combobox is called combo0 and the subform is called student details. Currently the subform displays all the records of all the students and i need it to only display the details of one student e.g. studentId, Course, Student_Type etc When i select the name of the student in the combobox.
  • orangeCat
    New Member
    • Dec 2007
    • 83

    #2
    How is the combobox set up?
    How do you restrict the data for the form to the one student?
    Take a look at Form OpenArgs

    Comment

    • katlego
      New Member
      • Mar 2010
      • 5

      #3
      Please be patient with me as i am still new to access. But from wat i understand the combobox is an unbound combobox. And i still havent figured out how to retrict the data to only one student because every time i try and view the form in form view the subform already has the details of one student displaying on it which does not match the details of the selected student in the combobox.

      Comment

      Working...