Error says field cannot be updated, but I can

[BillD]

In my database I have 4 forms set up in a tab control (contacts,
Registration, Regpayment, Contributions)
When I open the 4th tab (Contributions) and go to enter data I get an error
message that reads - Field Cannot Be Updated. I click on ok and close the
message box and the field I am trying to enter data in now accepts entries.
For example if I try to enter a date in the date field (08-12-08) When I
enter 0 the number won't enter and the message box opens. When I click on ok
the box closes and the 0 appears in the field. I can then enter the remainder
of the date and all the other fields in the form. This happens no matter what
field I try to make the first entry in when I open the form. Once I get by
the first error message everything works fine.
All the rest of the forms in the database work fine with no message or error
boxes.
I checked the table tblcontribution which the form is created from and all
the information that I enter in the form is saved in the table.

Any Ideas on what may be causing this problem, Also would like a discription
of how to correct this

Thanks

 

[Allen Browne]

So this happens at the instant that you start to enter a new value into the
4th subform?

Is this subform based on a query that uses 2 or more tables? If so, there's
a particular bug related to the Default Value property that your scenario
could have triggered.

Say the 4th subform is bound to a query that contains tblContribution, and a
tblContributionType table. You intend to add a new record to
tblContribution, but one of the fields in tblContributionType has a
DefaultValue. Access may (wrongly) try to apply that default value, and
since you are not adding a new record to tblContributionType, this attempt
fails. The error message notifies you of the failure, but then the
assignment of the new record to tblContribution proceeds fine.

If that's the cause, then removing the Default Value will solve it. Open
tblContributionType in design view, and remove anything in the Default Value
of any field. Then examine the text boxes on your form too: clear the
Default Value property from any control that's bound to a field in
tblContributionType.

This bug is not often seen, so you may have a different scenario, but
hopefully that's clear enough for you to track it down.

 

[BillD]

My form is made up of a query with two tables. I went into both tables and
removed all of the default values. I also checked the form and there were two
fields that do calculations with defaults of 0 I deleted them and then
checked the form operation.

Everything works fine.

Thanks so much for the help. I never would have thought that just a default
value would do that.