Combo Question

[DavidW]

How do you get a subform to load with what you populate a combobox with

Anotherwords I can put a number from another form into the combobox when the
2nd forms opens, but how do you get the subform to load on the second form
without reselecting the number from the combobox on the second form.
Hope I explained this correctly
Please Excuse My RedNeck Terminoligy

 

[ScottE]

Set the recordsource for the form that the subform is
based on to refer to the combobox. You can do this in VB
or in the form properties. An example: on a form
called "viewer", I have a combobox called "albumSelect".
In the form to which the subform links/is based on, the
recourdsource property refers to "forms!viewer!
albumSelect" as part of a "Where" clause. Then on the
main form, set the afterupdate event of the combobox to
requery the subform.

Hope this helps!