Editing New/Added Records on an .ADP Upsized Form

[Tim Stevens]

Hi,

My colleague and I who are currently working on an upsizing project to
convert from an Access .MDB format to a SQL-based .ADP format have run into
a major snag. Whilst all other data entry forms we have tested have so far
not produced any major problems in allowing the editing (and subsequent
updating) of records brought up by the source query - including added
records, a major form that we have been working with allows the addition of
new records as does its predecessor form in the .MDB format but it does not
either pass field parameters to this new record nor allow fields on this new
record in this form to be edited.

We do not seem to have problems editing already existing records on this
file. Nor do we have problems editing new records on other forms in this
project that are virtually identical in the form specifications, save that
the offending form is called along with a filter that refers back to the
calling form. When we remove this filter from this form, however, we still
do not have the ability to edit new records in this form.

We have tried several different possible solutions over the past week to fix
just this one problem - so far to no avail. If anyone in this forum or
related forums recognizes this problem or has any suggestion, I would be
extremely grateful as we are extremely frustrated and stressed out from
trying to find the solution to this one. Thanks in advance....

Tim

 

[Sylvain Lafontaine]

Read only forms are usually the consequence of a missing primary key. Make
sure that the upsizing wizard has set the primary key for the underlying
table. Also, make sure that the Unique Table property is also set.

There are others possibilities, too, and it's often difficult to find why a
form or a subform is set as read only by ADP.