Subform locks up main form

[sross81]

Whenever a user checks one of the check boxes on a subform linked to a main form and then tries to do anything on the main form the selections in the sub form are deleted because the main form thinks that the data in the sub form is still being edited. I have a case statement in vb for on error Case 3146 To 3621 that is generated.

Does anyone have any suggestions on how to refresh everything so that it is not locked up.

On the checkbox after update event I tried putting me.Checkboxname.RecordLocks = false and I have tried putting it into variance events on the form. I have also tried just me.refresh and me.requery. In every case as soon as I click anything on the main form the error 3146 to 3621 is generated again.

Please point me in the right direction if you can.

Thank you!

 

[lread123]

Hi
I have a similar issue, I have added a save button, and request the users to click prior to moving - works but can go back into the error msg loop if they forget.
Tried to figure out a save function after update (sort of thing) but gave up!
Hope this may help a bit!?

 

[sross81]

What code do you put in your save button click event?

I tried putting for example me.refresh and the checkboxname.refresh and various stuff like that in the after update event on the check box, although it doesn't error and I can step through and see it happens, it still locks everything up when they click off the sub form and back to the main form.

 

[sross81]

I have also tried this....If Me.Dirty Then Me.Dirty = False in the click and after update event on the check box and I still get errors like its being edited still. This actually happens as soon as I click on the sub form check box before I even try clicking on the main form. Its the only solution I see online.

 

[sross81]

The problem was that in the actual SQL table their was bit data types that didn't have a default value. When you try to delete or update from access, tables in SQL without a default value in a bit data type it will keep telling you that someone else is also editing the record.