Adding new fields to an previously existing form

[Freehal04]

I created two tables. The first is for info that is basic stuff like report
number, name, etc. The second table is for dates and comments. I created a
form with all the info. Later I needed to add a new field for a project
number. I added the column to my basic info table, but when I tried to add
the field to my form, the Field list didn't recognize the new entry of
'Project number' so I had to redo the whole form from scratch. What is the
proper way to add new fields to a form that already exists without having to
create a whole new form? Or is that not possible?

 

[Ken Sheridan]

It sounds like your form's RecordSource is a query which includes only the
original fields from when you created the form. If you open the query in
design view and then add the new field to a blank column in the design grid,
then save the query, you should be able to add it to the form in design view.

Ken Sheridan
Stafford, England

 

[Freehal04]

Alright, thanks a lot.

It sounds like your form's RecordSource is a query which includes only the
original fields from when you created the form. If you open the query in
design view and then add the new field to a blank column in the design grid,
then save the query, you should be able to add it to the form in design view.

Ken Sheridan
Stafford, England