combo boxes in a subform

G

Guest

is there any reason why a combo box would not work in a
subform ?

I have three combo boxes that run off each other depending
on the selection of the first combo which works fine in a
stand alone form but as soon as it's in a subform it
doesn't seem to respond.
 
T

Tony Vrolyk

If you are referencing the other combo boxes in code like
Forms!FormaName!ComboBox then the reference dies when in a subform. Change
the references to Me.ComboBox and it should work. You can also use the info
at the link below for referring to subforms and controls on subforms

http://www.mvps.org/access/forms/frm0031.htm
 

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

filter query on combo box in a continuous subform 0
synchronized Combo Boxes in subforms 2
More help needed on combo boxes 3
Link Child/Master Fields from Three Combo Boxes in Subform 2
Combo box Subform Control Default 2
combo boxes in subforms take 2 1
help with subforms and combo boxes please!! 4
Synchronized combo box in a subform 1

Top