Form appears "locked" can't enter info (subform is ok) 1

[rdy4trvl]

My form appears to be locked - I can no longer enter info (but the subform still works fine). I just get a “ping” when I try to enter info. This is a relatively simple (Access 101) Table feeding a Query that feeds a Form. I may have created the problem when I sorted the query so all records appear in order in the Form. I also changed the order of the columns in the query….none of this should have affected the Form. My table is still in tact and I can enter information in it with no problem. I tried deleting some of the fields from the query and form, then re-establishing them – but this had no impact. Any idea what I may have done to my form/query to “lock” it up? The Query is set to "no Record Locks" and the Form Selector is set as follows: Data entry to Yes; Record Locks to Edit, Allow edits, deletes and additions.

Thanks for any suggestions.

 

[rdy4trvl]

I compared the problem form with an almost identical form and could not find any different settings. Interesting I could not add a record (or change data) in the query either - so I'm guessing the problem was there...somewhere.

Here is my "go-around" solution. I deleted the problem query and replaced it with a new query naming it the same as the deleted query so there were no changes to the form. Not really a solution, but it works (until I step in the mud again).

 

[Steve101]

You have identified correctly that the problem is with the query and not the form.

Not knowing anything about the query, tts my guess that the query is a multi table query, and one or more of the join fields are not indexed. This situation does lead to the query being 'read only'

Hope this helps,





Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)