Bug in subform's Record Source when field added

[Kurt]

If one has a working subform, adds a new field to the subform's table,
then adds the field (control) to the subform, MS Access 2003
(11.6566.6568) SP2 will not see that new field in Form View. The string
"Name?" appears in the newly added control indicating a broken
reference. Updating the Record Source by adding the field to query and
saving doesn't help. If one does this in form view, the message
appears:

The Microsoft Jet database engine could not find the object
'~sq_ffsubServicesCompleted'. Make sure the object exists and that you
spell its name and path name correctly.

Clicking OK dismisses the box and resolves the problem, with values
appearing in the new control. Closing and opening the form makes the
problem recurr. The Record Source in design view shows that the field
got saved (originally it didn't), but the ref is still broken.
Compacting DB doesn't help.

I will now have to spend time reproducing the form from scratch to see
if the problem goes away. Be forewarned.

[Allen Browne]

Kurt, thanks for posting.

There are some issues in this zone, and the curiously named JET object does
indicate its inability to find the thing. What is bothersome is that the
problem recurred in your case when you re-opened the form.

I'm curious if you can solve the issue by unchecking the Name AutoCorrect
boxes under:
Tools | Options | General
and then compacting the database.

More info on some the issues associated with this misfeature:
http://allenbrowne.com/bug-03.html

--
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.

"Kurt" <k.*******@verizon.net> wrote in message
news:11**********************@y41g2000cwy.googlegr oups.com...

If one has a working subform, adds a new field to the subform's table,
then adds the field (control) to the subform, MS Access 2003
(11.6566.6568) SP2 will not see that new field in Form View. The string
"Name?" appears in the newly added control indicating a broken
reference. Updating the Record Source by adding the field to query and
saving doesn't help. If one does this in form view, the message
appears:

The Microsoft Jet database engine could not find the object
'~sq_ffsubServicesCompleted'. Make sure the object exists and that you
spell its name and path name correctly.

Clicking OK dismisses the box and resolves the problem, with values
appearing in the new control. Closing and opening the form makes the
problem recurr. The Record Source in design view shows that the field
got saved (originally it didn't), but the ref is still broken.
Compacting DB doesn't help.

I will now have to spend time reproducing the form from scratch to see
if the problem goes away. Be forewarned.