Adding a Field to a Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form which has a subform which is linked to a table which contains
the desired information.

I have created an additional field in the table and would like to get this
field on the subform.

Any suggestions would keep me from installing a springboard o the roof and
performing the perfiect swan dive.

Thanks.
 
Open the mainform in design view. Select the subform control, open
properties, go to the Data tab and note what is in the Source Object
property. Close properties and close the main form. Find the form that was
the subform control's Source Object in the list of forms at the database
window. Open that form in design view. Use the Toolbox in the menu at the
top of the screen to add a control for the new field. Select the new
control, open properties and set all the appropriate properties for that
control.
 
Thanks. I have grasped wuite a bit since I started using Access since Oct 03.
I think the word Control is beyond my experience. I took the steps you
mentioned and found I had to decide what Control to use ?

I deal alot with SQL databases and creating reports via Crystal. Never have
I been so lost. Maybe it is just a difference in terminology or I can't grasp
it.

Thanks again.
 
When you open a form in design view, all the items you see including labels
and command buttons are called controls and belong to the Controls
Collection in the object model. The Help file for Controls Collection has a
good descriptive writeup.
 
Back
Top