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

I知 trying to add a dropdown on a form to add information to separate reports.

P: 10
I知 trying to make a dropdown box in a form then what that person selects when they close the form it will save that to a table but I just can稚 get it to work. Any help is greatly appreciated!!
Jan 20 '19 #1

✓ answered by GKJR

The form needs to be bound to the table that you want the data saved in. In design view, under form properties and in the data tab, select the record source to be the table you want to update. You can also update records from a query if your relationships are properly set up. You then need to set the control source of each control to match the field they will be linked to.

Share this Question
Share on Google+
1 Reply


100+
P: 101
The form needs to be bound to the table that you want the data saved in. In design view, under form properties and in the data tab, select the record source to be the table you want to update. You can also update records from a query if your relationships are properly set up. You then need to set the control source of each control to match the field they will be linked to.
Jan 20 '19 #2

Post your reply

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