472,126 Members | 1,628 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,126 software developers and data experts.

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

Aug 9 '07 #1
3 1216
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
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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.