pass value from subform to main form

[lavanya]

how would i pass a combo box's selected value from a
subform to the main form's VBA code. There is no value on
the main form that will be updated from the combo box value
but the VBA code in the main form's command button will use
the value.

any help will be appreciated.

 

[Allen Browne]

See:
Referring to Controls on a Subform
at:
http://allenbrowne.com/casu-04.html

Note that the SourceObject of the subform control (the name of the form in
holds) can be different from its Name.