Tabs + Subforms + Add/Edit = 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

[Rabbit]

I'm not quite sure how you set this up but when I want a search and edit/add on the same form, I'll use a listbox for the search. The listbox returns the primary key and I use that to navigate to that record on the form.

[hkmulligan]

Exactly, except i have it on two separate tabs. Even more interesting is I found when I give the primary form the record source "Workgroups" the problem stops, but suddenly i can only see the search results of the selected record in the primary form... weird

[Rabbit]

Could you go into a little more detail?

What is the record source.
How are you managing the search?