Adding new fields to an existing form/subform

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

If a table is updated with a new field, is there any way
to add that field to an existing form/report. I have
tried using an expression in an unbound field but
something is going wrong!

Many thanks in advance

L
 
Hi Linda

if the form / report takes its record source directly from the table then
you can display the 'field list' (it's a little box on the toolbar when in
design view of either forms or reports .. also found under view / field
list ) and then you can drag the new field on the the form / report

if the form / report is based on a query, ensure the query has the field in
it and then you can use the 'field list' icon to get it onto the
form/report.

Hope this helps
Cheers
JulieD
 
If the RecordSource of your Form / Report is the Table to which you added
the Field, the new Field should be available and you can set the new Filed
as the ControlSource of the Control (Textbox?).

If the RecordSource is a Query or SQL String, you need to modify this to
include the new Field in the Query / SQL String before you can use the new
Field as the ControlSource.
 
What if the field is in another table? How can you add a field to the form
that has its recordsource from tblOne but the field is in tbl 2? What about
putting fields from several tables on one form without creating a subform?

Thanks,
Another Linda
 
If you don't want to update the Field in Table2, you can simply use a
Calculated Control with DLookUp() function.

If you do, you will need to create a Query linking & selecting data from 2
Tables and use the Query as the RecordSource for the Form. The alternative
is to base the Form on Table1 and use VBA code to handle the editing of data
from Table2.
 
Back
Top