469,898 Members | 1,837 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

Tabs + Subforms + Add/Edit = No Go?

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
Aug 9 '07 #1
3 1168
Rabbit
12,516 Expert Mod 8TB
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.
Aug 9 '07 #2
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
Aug 10 '07 #3
Rabbit
12,516 Expert Mod 8TB
Could you go into a little more detail?

What is the record source.
How are you managing the search?
Aug 10 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by ghadley_00 | last post: by
7 posts views Thread by jaad | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.