Adding new fields to existing forms/reports

[Guest]

I have some existing forms and reports that i have built through the
wizards. How do i add new fields from the same or other tables. If i add a
new text box etc how do i link it up to the field i want it to display on the
same record(s) that the exsisting form is displaying

 

[BruceM]

If the field is in the Record Source for the form or report, you can either
drag the field from the field list onto the report, or you can set the
Control Source for the text box to the field. To do that you need to open
the property sheet for the text box: Right click the text box, click View >
Properties, click the Data tab, click in the Control Source row, click the
down arrow at the right side of the row, and select the field.
Regarding adding a field from another table, without knowing what you are
trying to accomplish the answer must be a little vague. In general the
field needs to be in a table that is related to the Record Source table, and
it needs either to be included in a Record Source query that also includes
the original table, or it needs to be in a subform.

 

[kingston via AccessMonster.com]

Go into design mode of the form and open the field list window (look for list
icon button). There you'll find available fields for the form based on the
form's record source. Just drag items from the list to the form to add them.
If the field list does not contain the item you're looking for, you'll have
to modify the form's record source. Generally, this is done by modifying the
underlying table or query or creating an entirely new query.

You can also place a new control on the form via the form design toolbox.
For textboxes, you can change the control source to the desired field. For
comboboxes and listboxes, a wizard will help you set up the control. HTH

 

[Guest]

Yes i need to add to the field list. How do i do that.

I have a related table from which i want to add new exisitng fields which
should be theoretically do-able.

My exisintg tables "Registration" & "Everyone" have fields selected, they
are related through a field Everyone ID which is PK in "Everyone" and i want
to add data from my "Training Course" table that is related to the
Registration table through a field "Trainig Course ID" that is not currently
selected.

I'm selecting which records to display through a button on a prevuos form
and need to display fields from "Training Course" as well.

 

[BruceM]

You add to the field list by opening in design view the table that is the
form's Record Source, and adding the fields you need. To have fields from a
second table appear in the field list you would need to combine the tables
in a query, and use that query as the Record Source.
It sounds as if each person in Everyone may take several courses, and each
course may contain several people. In that case there is a many-to-many
relationship between people and courses, which would be resolved through the
Registration table. Is that your setup? I won't go into detail unless
there is a need.