By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,658 Members | 1,519 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,658 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.

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


Rabbit
Expert Mod 10K+
P: 12,324
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

MMcCarthy
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.

Mary
Feb 21 '07 #3

Post your reply

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