Write conflict access subforms
Posted on 2006-11-12
I have a form that has 5 subforms. The main form is just a housing to do things like search via a combo box and it takes you to that record. The subforms are different parts of each record. 3 of the subforms all refer to the same table, just different parts of the data in each subform. The main form links with the subforms so no matter what subform you are workng on it stays on th same record, until you switch to a different record. Recently, subform 2 has popped up the write conflict error when user trys to go to another record after change was made to a field. If i select copy to clipboard, the data is from subform 1. It's almost like the first subform is holdng the data open and not allowing the 2nd subform to enter anything. If I open any of the subforms without the parent, they work flawlessly. I have searched for an answer to this for about 8 hours now and am a little frustrated to say the least. I'm self taught on VBA so please be gentle.