Tabs + Subforms + Data Entry = No Go

[hkmulligan]

So here's the situation.

I have a form with two tabs.

Tab One: Search feature through a qry. I change the SQL of the qry for each search.
Access -> qrySearch which access -> tblWorkgroups, tblRules

Tab Two: Displays the workgroups for reading/adding/editing
Accesses -> tblWorkgroup, tblRules

Problem: Once I added the search function I was no longer able to add/edit the records under the Workgroup tab. I've read this is because I access the same tables on multiple tabs. Any ideas on how to fix this? (I really don't want to have to do it in two windows )

Thanks
hkmulligan