Form locked, unable to unlock

[Koen]

Hi all,
I'm having a problem here and after searching the web, I can't find a solution.
Problem is that I have a form which seems to be locked. None of the fields can be modified. This should be ok except for 1 combo-box.
I have checked all objects settings and all objects have:
Edit/Delete/Add options enabled;
Visible option enabled;
Locked option disabled;
The form has only Fromview enabled and recordlock is off.
There is no VB code modifying a 'locked' status.

Can someone help me out here?

My project is +20Mb so first I'd like to see if there are any things I've forgotten to check before I'll strip and post it.

 

[Meltdown]

A locked form (that has not been intentionally locked), usually indicates a broken relationship. Open up the relationship window and verify the relationship between your tables.

 

[ssoltic]

Maybe your form is based on summarized or crosstab query?

 

[Koen]

hi, my form is not based on a summarized or crosstab query, so this can not be the problem.

However, I will check all the relations in my project.
It seems to me that the relations function in Access is rather buggy (refusing to make relations without reason, refusing to modify relations etc.). Also the 'print relations' functions does not work properly, but that's on mr. Gates' account ;-)
I added some fields from a new query to my form recently and there might be an inconsistency in the relations of the queries and the relations of the database.

 

[JAB]

My Form is Locked Also

This same problem occurred in my database just last Thursday (2/10/05). I have a form for manufactured products and a subform for direct labor hour time details assigned to each product. I cannot add a new record nor make changes to any existing records in the subform. There was one change I can describe that occurred just prior to discovering this problem:

The subform is based on a query where tblProductStds (the Many side) is linked to tblProducts (the One side). Linked to tblProductStds is tblWorkcenters which contains the field Load Factor. This field is displayed in the subform and used in a calculated control on the subform. It was supposed to be locked but a coworker discovered he could make changes to it, which of course would change the value stored in tblWorkcenters. After reprimanding him for being one of those pesky users who can't leave well enough alone I locked the Load Factor control on the subform. Since that time the entire subform has been locked. So then my next step was to replace this subform with one from a backup database. But first I made sure the replacement form worked with the Load Factor control locked, and it did. But after importing it into the main database it is locked! I hope this has provided enough clues for someone to come up with an answer. I really do not want to re-create the input form but if needed...

 

[JAB]

Form is Now Unlocked

Here is an update. Just after replying to this thread it occurred to me that I should also try replacing the main form from the backup database. I did and now I am back in business. The replacement main and subforms are working correctly again.