mali sg said:
how to specify fields from same table to be used more than once in form or
report?
Simply bring up the form in design mode, and then from the menu go
view->field list.
You can then drag any field from that list on to the form or report.
It important to point out that you don't place "fields" on a form, but in
fact place what is called a text box.
It is a common misconception that the name of the text box on a form has to
be the same name as the underlying field name. the fact that they have both
the same name is only done for convenience sake.
Hence, you can have a field called:
Company,
but place 3 text boxes on your form called:
text1
text2
text3
And, all of the above text boxes can show the company name. What "field" a
text displays has NO relation to the text box name. You find the setting for
what "field" a text box is connected to in the "data" tab of the properties
sheet for that control (that setting is called the control source).
So, there no restrictions in any way as to placing a text on a form 10
times, and they all are connected to the same underlying field.
You will note that if you drag and drop the field from the displayed field
list onto the form, the first time you do this, the text box WILL have the
same name as the field, but each additional time you drag and drop that
field on to the form, you see automatic naming of the text boxes (text1
text2 etc.).
You can also change the name of the text box by displaying the property
sheet and changing the name in the "other" tab....
