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

Having a listbox that will populate multiple items in another table.

P: 5
Hello everyone. Im running Access 2007. The form i created logs a persons ID badge number and personal information however, i want to make a section that lists their skills. So I will add a button on that form that will open a pop up. In that pop up i will have a list box of all the skills you can pick from. Right next to it will be a text box that will display the items you have added so far. After you hit the ok button. The items will now appear on the other form. How do i go about doing this. They are two seperate tables. One table is named skills which has one column that is labeled skill code with 30 entries. The other Table Is for the persons name , phone number, ID bade... etc. Their is a column in that table labeled skills. How do i populate that column with information from another table. Also i have to be able to add multiple entries and not just one in that one field. Thanks

Aug 8 '07 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 10K+
P: 12,401
Why don't you set up a subform instead?
Aug 20 '07 #2

P: 90
sorry to hear your using 07 but like Rabit said a subform would be much simpler and you could even put it on a tab
Aug 20 '07 #3

P: 90
on second thought you could have a sub form in data sheet view with bolean fields on click of ok run an append query to your main forms table were the bolean fields = true hope that helps
Aug 20 '07 #4

Post your reply

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