Update a field on a Subform from a combo box

  • Thread starter Thread starter Greg Ripper
  • Start date Start date
G

Greg Ripper

I have a form, frmdiscipline, that has 1 combo box, cbodiscipline, and 2 subforms,
tbldiscipline subform, tbldiscipline subform1.

cbodiscipline pulls 3 values from a query, discid, studentid, studentname.

tbldiscipline subform is linked via a master and child field, discid, and
opens just fine.

Subform 2 needs a different value from cboDisciple, studentid.

How do I get a value from a combo box when it is not the bound column? Sorry
to take so long to get to that, but I think it helps to understand what is
going on.

Thanks as Always,
Rip
 
You get to the non-bound column info on a ComboBox by using
the Column property (with a zero based index)

e.g. cbodiscipline.column(1) should yield the studentid

Hope That Helps
Gerald Stanley MCSD
 
Back
Top