Unbound Mainform, Unbound datasheet Subform data to a textbox (1 Viewer)

[Hudas]

Hello!

I need help!.. I have an unbound mainform and an unbound subform(datasheet). The source of the subform is a query which is dynamic(I have many queries with diffrent columns). the subform source is change using a combo box selection. I have text boxes in my mainform... my question is how do I get the data from subform to the text boxes of the mainform?

Thank you
hudas

 

[Mihail]

VBA:
Use the "OnClick" event for the combo.

Private Sub ComboName_Click()
   Me.SubformName.Rowsource = ComboName.Text
   Me.SubformName.Requery
End Sub

Note that this code is not tested but for sure is very close to your needs.

 

[Mihail]

I forgot to say that this is not the right way to do your job.
Learn about queries with parameters and use such a query as rowsource for your subform