Control Subform Data by main form CombolBox

[SwingXH]

I would like to put a subform on a main form to show the records. And the records on the subform should be controled by a comboBox on the main form,values of which the user can change.

I knew how to display the records on a separate form. The codes look like
DoCmd.OpenForm "FormName",,,"FieldName=" &Me ("ComboName").Value

But how to make the similar function but on a subform?
Thanks a lot!
SwingXH

 

[SarahG]

Make the recordsource of your subform point to a query. This query will extract the required details with the criteria you indicated:

FieldName=Forms!YourFormName!ComboName

 

[PHV]

how to make the similar function but on a subform
Playing with the subform's RecordSource property and Requery method in the AfterUpdate event procedure of the combo.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SwingXH]

Thank you very much to SarahG!
Many thanks to PHV for helping me on many questions!

SwingXH