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

How can add one field from query to form?

P: 6
I prepared form for query but I do not know how to add one field from query to form.
Jan 7 '14 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 5K+
P: 5,397

This is one of the most basic of operations:
The easiest method is to open the form in design view
Make sure the form is bound to a record source (it need not be; however, that is an advanced design) by right clicking on the form and selecting "form properties", data tab, look at the [record source] property. This should be set to your query, a table, or an embeded SQL if not then set it to your query, there is a dropdown list.

Once this is done, all you need to is "add exsisting fields"
Now because you haven't told me which version of Access you are using, you'll have to hunt some; however, in ACC2010 in the ribbon, Form Design Tools context-ribbon (means the form needs to be in design view and active) design subtab, you will see the control, click, and then drag-n-drop. The type of control dropped will depend on the field design in the table/query - usually a text box.

You can then alter properties etc... however, before you start that you should work thru the following sites, without these basics, you wont be able to get the most from our help (^_^)
That last entry, "normalization" is something that you really need to develop a good understanding of - it provides a tool that makes database design easier to maintain, and more importaintly, easier to data-mine!
Jan 7 '14 #2

Post your reply

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