CODEWITHSUNDEEP
ms-accessvba
Adam
Adam

Reputation: 1011

MS Access: How to Programmatically Add a Subform

Is there a way to programmatically add a subform to a form using Access VBA? I have a temporary table that is generated dynamically when requested by the user. If possible, I would like to create a form based on the temporary table and add it as a subform to a pre-existing form.

Upvotes: 5

Views: 8650

Answers (1)

Fionnuala
Fionnuala

Reputation: 91316

The best bet is to create the subform control and set the source object to either a table or a query.

Me.NameOfSubformControl.SourceObject = "Query.Query1"
Me.NameOfSubformControl.SourceObject = "Table.Temp"

It is also possible to update the sql of a saved query to reference the new temp table.

Upvotes: 5

Related Questions