Listing a record in a subform from a combo box

  • Thread starter Thread starter greg
  • Start date Start date
G

greg

I have a combo box (cboSelectStudent) and a subform in single form view.
The combo box is from a query of student names who were tardy today. How
do I get the subform to use the name selected in the combo box and access
the student's record in the table, tblStudentData? I swear this is the last
question I'll post today if someone can help me.

Greg
The dabbling in the confusing world of Access
 
greg,

You are probably using the name not the student id. I'm
guessing that you want to set the colum on the list to
read and store the student ID not the student name
(properties for combobox). Then on the sub form it can
open the table for that student record, i also find that
after selecting info in combobox it is less confusing if
it goes to a sorted form based on the combo box rather
than a sub form. you can set up a button to take you to
that form simply with the wizard.

Anyhow It needs to use a primary key to sort the student
records, or use a query based on the combobox to produce
the sub-form for that student. I've done this and had
access looking at the wrong column so that it had to much
info to sort, so the subform would not give me what i
wanted.

Hope this helps
 
Back
Top