New field added in form

  • Thread starter Thread starter Brenda
  • Start date Start date
B

Brenda

Hi there
My problem is: I have a table and form created already. I
now want to add another field to the table and then go to
the form and add it in there. I've put it in the table
but when I bring up the list to choose for the form - the
new field isn't in there. Any help would be very much
appreciated.
 
It depends on your form datasource. If it is based on a
table sometimes it won't refresh right away and no doubt
when you came back to the database after being frustrated
and closing it the field was available. If you base your
form datasource on a query then perhaps the new field was
not included in your datasource query?

Audrey
 
Hi there
My problem is: I have a table and form created already. I
now want to add another field to the table and then go to
the form and add it in there. I've put it in the table
but when I bring up the list to choose for the form - the
new field isn't in there. Any help would be very much
appreciated.
Click to expand...

The problem is that the Form's Recordsource has been created using the
old table definition. Open your Form in design view and view its
Properties; select the Data tab and click the ... icon by the
Recordsource property. This will open a Query window showing the
table(s) and fields in the Form's Recordsource.

Add the new field, close the window, and accept Access' offer to save
the SQL. Your new field will now be available.
 
Back
Top