Ahmedamer:
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!
6
