Tab control source

[vipersmind]

I have a form that has many tabs the control source for the form is tblEOM_Selection and this table is populated by a query qryEOM_SelectionAD.
the on change event for the Tab control is set to

Private Sub TabCtl0_Change() 
     If TabCtl0.Value = 1 Then 
         DoCmd.Openquery "qryEOM_selectionBD"
     Elseif TabCtl0.Value = 2 Then
         DoCmd.Openquery " qryEOM_selectionCA"
     End if

End Sub

so for each tab that I click I would like to fire another query.

This works OK but the queries all write to the same table, that is the control source of the Form and says that the source is lock by another process. I understand what is happening. The table it's writing to is locked by the open form.
I would like to know if I can have a different control source for each tab or will I be better doing something else????