By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,291 Members | 1,592 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,291 IT Pros & Developers. It's quick & easy.

Tabs + Subforms + Add/Edit = No Go?

P: 2
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 :( )

Aug 9 '07 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 10K+
P: 12,392
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

P: 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

Expert Mod 10K+
P: 12,392
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.