Fields lock randomly on subform

[zosta]

Hi everyone..



I have a database which is linked to several sharepoint tables (lists). These tables are queried based on choice in main form. In the main form there are several subforms built on those queries. The subforms are placed on number of pages in tab control.
The problem is that the fields get locked randomly and do not allow any edits. The fields like dates or comboboxes can be updated using mouse, but if one tries to type in something there is no response.
After some random clicking around, opening different pages etc. the same fields can be eventualy edited.
The subforms, when opened as a stand alone forms, work fine and there is no problems wih locking.
I have checked all possible "Allow edits" properties and they are all set to "yes".

Since I cannot discover any pattern on when the field is locked and when is not, it is extremely frustrating.

I'll be grateful for any ideas.

[rpeare]

look in your code for any .enabled or .locked values being set. You should also examine your dataset. If the source for the data is being re-written (i.e. a dynamically created SQL statement) there may be some problem with the SQL statement (i.e. linking one to many tables incorrectly).

[zosta]

Thanks. I am quite sure there is nothing of that kind in the code. All sql statements use single tables or queries. Queries are executed with .execute. I use also dao recordsets to control the content in case of no value etc. It might be that there is some conflict, but I cannot figure out where.

[rpeare]

did you check my other suggestion

[Missinglinq]

The subforms, when opened as a stand alone forms, work fine and there is no problems wih locking.

I have checked all possible "Allow edits" properties and they are all set to "yes".

Including the AllowEdits Property on the Main Form? Can you Edit Records on the Main Form? If AllowEdits is set to No/False for the Main Form, or if the Main Form is Read-Only, no Subform Records can be added to or edited, because they reside on Subform Controls on the Main Form, and Access considers anything you attempt to do to these Controls as 'editing.'

Linq ;0)>

[zosta]

Yes. Note that it happes occasionally that edits are possible also by using combos so Allow edits must be set to Yes.

[Missinglinq]

Given that, the on-again, off-again nature of this thing, if it were a standard database, would lead me to think about corruption of the Form. The first line of defense, for this sort of thing, is usually to create a new, blank file, and import all Objects into it. It works an amazingly large number of times, and only takes a minute or two to do..

Few of us, here, use Sharepoint together with Access, VBA code not being functional with Sharepoint. That said, you have to wonder if the problem has to do with the network connection coming and going. Not my area of expertise, but maybe someone else will wander by who can help.

Linq ;0)>

[zosta]

Looks like I have pin pointed the problem. I had two subforms on different tabs based on queries using the same table. The first subform remained locked until I clicked on the tab containing the other one. After getting back to the first one the edits were possible. When the other subform is removed it seems OK (so far). I am not sure what is causing the problem and will need to have a closer look.