How to Update and add New Fields in an Existing Form

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

Hello;
I have a problem that needs help.
I have an existing form that works great which is based
on an existing table.

I have added new fields to the existing table and have
updated the "lookup" on one of the fields.

I go into my existing form and want to

1.Add the new fields
2.Update the existing field with the new "lookup" details

All without having to redisign the rather extensive form.
The new fields do not appear in the "display fields" list
on the form design toolbar.

Is there a way of updating the available fields list in
the form design window with the latest and greatest new
fields and changes from the existing table?

Many thanks for your help...Richard
 
I had a similar problem when updating my lookup fields and
I found that if I went to the design view on the
particular form you are needing to update and going to the
properties dialog box, choose the record source double
arrow box and it should open your forms record source. In
my case it was based on a query. Then check your record
source to see if it contains the updated lookup fields and
if not you can 'add table' here and drop your new updated
field into your record source. But you must update the
lookup fields first in your original table or record
source. To add the new fields go to your toolbox in your
form on design view and click which control you are using
to enter your data ie. combo box and then make sure it is
referencing your new control source.
 
Back
Top