failure in saving new added field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

- - 27 Dec 2005 07:59 GMT

I had added a new field to a form, and try insert the data to the new
created table field. But when i try to assign the a control source for that
form field, in the control source drop down list it doesn't show the new
field from that table.
Got any solution to solve this problem?

Reply to this Message

Greg Murrie - 27 Dec 2005 08:03 GMT

I had this same issue earlier tonight. The problem is that it seems access
takes a "snapshot" of your table when it opens. The only solution I found
was to exit access, and get right back in. At that point, my newly added
field(s) were there.

> I had added a new field to a form, and try insert the data to the new
> created table field. But when i try to assign the a control source for that
> form field, in the control source drop down list it doesn't show the new
> field from that table.
> Got any solution to solve this problem?

Reply to this Message

darkroomdevil - 27 Dec 2005 08:10 GMT

I think this is what you mean ...

>I had added a new field to a form, and try insert the data to the new
>created table field.

I created a new field in a table, then added the new field to my form.

>But when i try to assign the a control source for that
>form field, in the control source drop down list it doesn't show the new
>field from that table.
>Got any solution to solve this problem?

Did you save the table?
Is the record source of the form the same table? check spelling!

Reply to this Message

Allen Browne - 27 Dec 2005 11:03 GMT

Save any changes you have made to the form.
Close it.

After adding the new field to your table, saving the change, and closing the
table, open the form again in design view, and you should see the new field
appear in the field list now.

If it still does not appear, make sure the Name AutoCorrect boxes are
unchecked under:
Tools | Options | General
and then compact the database.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I had added a new field to a form, and try insert the data to the new
>created table field. But when i try to assign the a control source for that
>form field, in the control source drop down list it doesn't show the new
>field from that table.
> Got any solution to solve this problem?

Reply to this Message

Steve - 27 Dec 2005 20:35 GMT

What happens if you simply close the form and reopen it?

I usually just type in the control source for my fields if they don't
show up in the Field List or in the Control Source drop-down. You know
it exists, it's just not visible.

Reply to this Message

Wayne Gillespie - 28 Dec 2005 00:21 GMT

>I had added a new field to a form, and try insert the data to the new
>created table field. But when i try to assign the a control source for that
>form field, in the control source drop down list it doesn't show the new
>field from that table.
>Got any solution to solve this problem?

I have found that going to SQL view of the form's recordsource, highlighting all text (Ctrl A), cutting all text (Ctrl
X) and immediately pasting the text back (Ctrl V) will force the structure to be re-evaluated and the new fields will
show up.

Wayne Gillespie
Gosford NSW Australia

Reply to this Message