473,320 Members | 2,054 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 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 :( )

Thanks
hkmulligan
Aug 9 '07 #1
3 1254
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

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

Similar topics

0
by: misscrf | last post by:
I am currently working on a database, in 3rd normal form, which is for candidates who apply for a job with the law firm that I workd for. My issue is with good form design. I have a main...
1
by: ghadley_00 | last post by:
I have an MS Access Database with multiple forms that all update fields in a single table because I can't fit all the required fields onto a single screen. I have looked into converting these...
1
by: natwong | last post by:
Hi All, I'm hoping that someone could help me out since I'm new with Access. Background: Database was set up as a simple data entry and reporting tool for Program Initiatives. The data...
4
matrekz42
by: matrekz42 | last post by:
Hello Gurus, I currently have a form that houses multiple subforms and it's all on tabs, within the form. I have a query that I want the date range to be called from a DatePickr that is in one...
0
by: TD | last post by:
I have a main form with two subforms (both in datasheet view), neither of which are linked to the main form. The main form is based on a query that uses the bound column of a combobox on the main...
4
by: Rich P | last post by:
Maybe you could try using a query as the recordsource for your subforms and for the criteria field in the query you could use a Form parameter. This way - instead of using the form filter property...
2
by: pankajsingh5k | last post by:
Dear All, Please help me... I had read an article to lazy load a tab in a tabcontainer using an update panel on http://mattberseth.com/blog/2007/07/how_to_lazyload_tabpanels_with.html ...
6
by: Sarvananda | last post by:
I have two forms: 1. Donor 2. Patron I want to bring the two forms together in a tab control on separate pages. I had some startup actions to be triggered for each form. Which event in the...
7
by: jaad | last post by:
While at it I have another one that has been bugging me to no extent: I have a work order form, this work order form has a subform called Work order details, there is another form attach to that...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.