My access database seems to have a mind of its own- it was working fine, I added an update query to insert a new field on table and calculate a date.
When trying to edit data on the main form, the record acts locked, but when I click on link to subform and update it first, then go back to main form, it allows editing of data.
I have no problem putting in new data on main form.
I checked the user permission, properties on forms its all set at proper properties: locked(no), enabled(yes), allow edit,addition, deletion (yes), locked(no) etc. also the VB codes look fine
My thinking is the record lock is due to the calculating query, or maybe its the cycle – I’m not sure.
Please help
