how to populate a subform from table

[Dengkee]

hi,



i have a form with a subform, all i need is a button to populate my subform from the table i specify. can anyone help me?


dennis

[NTC]

Your post begs the question of what is your fundamental design that would require a form/subform to be dynamically changing its record source...? It is an unusual requirement and probably a sign that the db design should be changed.

Having said that, I will enable you further in this potentially bad design with the technical solution as follows:
If you want to change the recordsource of a subform use: Me.NameOfSubformcontrol.Form.RecordSource = "NameOfRecordSource"