Form to dynamically allow user to add/edit lookup tables data

[pats2kdynasty]

I have a bunch up lookup tables that I want to allow the user to edit.

I am trying to accomplish this via one form with a drop-down list of the lookup tables. When the user selects a table the subform appears below with table (datasheet view). I know how to set the datasource, but how do I dynamically make the fields appear on the subform....or is there an easier way to handle this.

Any help, downloads, examples, links, etc. would be greatly appreciated.

Thanks.

[Rabbit]

You'll either have to change the record source and control source of all the controls in the subform to reflect the new table or you can have a different form for each table and just change the source object of the subform.

[MMcCarthy]

The only other way to handle this is to use a listbox instead of a subform. This would work if you don't need to edit the records. You would have to set the column count to the column count of the largest table.

Mary