Subform error - Cannot update Field

T

TimT

This wierd.
When I go to update a field in a subform I get an error msgbox that says
"Field Cannot be Updated"
I must be missing something in the form properties but i don't know I'm
missing here.
Any help?
 
O

Ofer

Check the following:
1. Run the sql you use for record source of the subform seperatly, and see
if you can update it, if you cant then will continue from here.
If you can update then check the sub form properties
2. Check if the AllowEdits Property set to true
If yes
3. check the properties of the sub form under the form, if the lock property
set to false
 
T

TimT

Ofer thanks,
Here is another part of this mystery that I forgot to mention.
when I get the error message, if I click ok the error comes back 5 or 6
times in a row then it goes away and I can update the subform. If I click
help it reads:

Field cannot be updated. (Error 3164)
Possible causes:

You tried to update a field in a record or table that is currently locked by
another user. Wait for the other user to finish working with the record or
table, and then try the operation again.
In Microsoft® Access, you tried to change the value of a control whose
Locked property is set to Yes.

So now I'm really confused.
 
O

Ofer

Do you get the message when you try to update, or as you enter the field?
Do you have any code under the field you are trying to update?
 
U

UpRider

See if you have set default values for controls on the form. Sounds like
maybe you have 5 or 6 of them.

UpRider
 
E

EJH

Ofer.
I am having a similar problem. My subform is a datasheet off of a query.
If I bring up the subform by itself, it will update the tables, however it
then is not linked with the same info of the main form. But if I try to do
it within the main form, I get the same error Tim was having. I checked the
form properties as you suggested and they are correct. Any help would be
appreciated.

Ed
 
E

EJH

I think I may have had a corrupted database. I created a new database and
imported by tables and then I re-created the form and it works and updates
as it should.
 
Top