Subform error - Cannot update Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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.
 
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?
 
No code. and it does it after update when focus is lost.
I did try to change the data source from a query to the table and it worked,
but then I'm going to missing information. From the description of the help
file for that error it seems that the query is busy??? what the &*^%? But
somehow it makes sense because when your done clicking ok 5-6 times it saves
the update and then you can go back to that subform and add or update any
field - this error only happens when the main form first opens up and you use
the subform for the first time on that session.....
 
See if you have set default values for controls on the form. Sounds like
maybe you have 5 or 6 of them.

UpRider
 
Back
Top