CODEWITHSUNDEEP
formsms-accesscombobox
Flow74
Flow74

Reputation: 73

MS Access: Showing a non specific Table on a form

Is it possible to show a table on a form, by selecting it with a ComboBox?

For example: I have a ComboBox in which the user can select any Table from the DB. After selecting a specific Table the columns of the Table shall be shown in a list on the form.

I hope you understand my problem :P

Upvotes: 0

Views: 53

Answers (1)

Andre
Andre

Reputation: 27634

Create an empty subform control on your main form. Name it e.g. subformTable.

Then in the AfterUpdate event of the combobox, set the SourceObject property to Table.yourtable:

Me.subformTable.SourceObject = "Table." & Me.cboTables

Upvotes: 2

Related Questions