D
Doug
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.
(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.