By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,028 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,028 IT Pros & Developers. It's quick & easy.

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

P: 1
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.

Feb 20 '07 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 10K+
P: 12,366
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.
Feb 20 '07 #2

Expert Mod 10K+
P: 14,534
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.

Feb 21 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.