Combo Selection on form becomes default value of combo on subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been struggling with trying to make the value selected in a combo box
of my form become the default value for combo boxes in subforms. On the main
form, my combo box allows me to choose the primary wood used in a room. On
the sub-forms I will choose the wood used in details of the room. Most of
these will be the same as the primary wood, but often, a contrasting wood
will be used for certain details, so even though they start showing the
primary, they must be changeable.

Can anyone help me? I've read the books, but can't seem to catch the concept.

Thanks for any help.
 
NancyMima said:
I have been struggling with trying to make the value selected in a combo box
of my form become the default value for combo boxes in subforms. On the main
form, my combo box allows me to choose the primary wood used in a room. On
the sub-forms I will choose the wood used in details of the room. Most of
these will be the same as the primary wood, but often, a contrasting wood
will be used for certain details, so even though they start showing the
primary, they must be changeable.

Can anyone help me? I've read the books, but can't seem to catch the concept.

Thanks for any help.
Click to expand...

cboFieldName <-- on subform
Default Value = "=[Forms]![YourMainFormName]![YourFieldName]"

* Watch out for NULL values and using subform on it's own.

HTH - John
 
Back
Top