Update a field on a Subform from a combo box

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
 
G

Gerald Stanley

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update from a Combo box 1
Referencing from a combo box 4
Pause Subform 1
filter query on combo box in a continuous subform 0
Combo box to search on a field in the subform 1
synchronized Combo Boxes in subforms 2
Subform dependent combo box 4
link in subform for 2 fields 4

Top