Adding new fields to an previously existing form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Freehal04 - 30 Oct 2006 19:59 GMT

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?

Reply to this Message

Ken Sheridan - 30 Oct 2006 20:14 GMT

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

> 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
[quoted text clipped - 4 lines]
> 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?

Reply to this Message

Freehal04 - 31 Oct 2006 18:54 GMT

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
[quoted text clipped - 12 lines]
> > 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?

Reply to this Message