473,326 Members | 2,104 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,326 software developers and data experts.

SubForms Not working properly

166 100+
Hello:

I am currently working on a project that will allow for updates to the db via forms. The problem is that I can not get the forms populated correctly. I am using a main form and 2 subforms. My issue is that I can not get the data populated in the second subform. I tried to get around this issue by trying to use nested forms however, the same problem has occurred. I am unable to get the second subform populated. In the main form, information is being pulled via a table w/ a primary key, that is a fk in another table, which is the dcontrol source for the subform 1. in subform 1, the pk is a fk in the table which is the control source for the subform 2. From what I have read, this should be sufficient for the information to populate each subform, based on the selection on the main form, which is done via dropdown menu.

I appreciate any insight you may have to offer. Thank you.
Mar 19 '08 #1
1 1455
JustJim
407 Expert 256MB
Hello:

I am currently working on a project that will allow for updates to the db via forms. The problem is that I can not get the forms populated correctly. I am using a main form and 2 subforms. My issue is that I can not get the data populated in the second subform. I tried to get around this issue by trying to use nested forms however, the same problem has occurred. I am unable to get the second subform populated. In the main form, information is being pulled via a table w/ a primary key, that is a fk in another table, which is the dcontrol source for the subform 1. in subform 1, the pk is a fk in the table which is the control source for the subform 2. From what I have read, this should be sufficient for the information to populate each subform, based on the selection on the main form, which is done via dropdown menu.

I appreciate any insight you may have to offer. Thank you.
Before you get too caught up in sub-forms, try to write a query that will use the three tables and select the data you want. If you can get a query that gets the data you need, you just need one main form based on that query.

If required, your query could use the GROUP BY clause, and the form could use group headers/footers to accommodate this.

Jim
PS Welcome to The Scripts
Mar 20 '08 #2

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

Similar topics

1
by: Alan Bloom | last post by:
I'm designing a db which stores client details but each client has multiple 'occasions'. For each occasion there is a section which has items purchased (there are sometimes none, sometimes...
6
by: Steve | last post by:
I have a form, primary subform and secondary subform. A tab control takes up all the area of the primary subform. There are about 15 tabs on the tabcontrol. Each tab contains fields from the same...
3
by: Diana Gard | last post by:
Perhaps this is a design flaw, please let me know. I'm using Access 2000. I have a form with a tab control and 5 subforms within those tabs. The forms match with the tables: Client main,...
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...
5
by: Richard Stanton | last post by:
Hello all My database has a main form linked to table1. It has several subforms on the main form, all linked to table2. Table1 and Table2 are linked by primary/foreign key, no duplicates...
4
by: microb0x | last post by:
I have an application with a master form with a tab control containing nine tabs, each tab contains a subform. I have command buttons on my main form including: Save , Cancel , Close. My...
2
by: collegekid | last post by:
Hi everyone, basically my problem is this: I am using an Access 2000 format. And--I have four subforms in my main form. (Purpose of this is to track projects.) So in my main form I enter the...
1
by: Ecohouse | last post by:
I have a main form with two subforms. The second subform has a combo box whose recordsource is set based on a field in the first subform. I tried putting some code in the first subform to do...
4
by: Harlequin | last post by:
I have a question concerning the need to trigger events within a "child" subform which is itself enbedded within a master "parent" form and which is accessible via a tab in the parent form. Becuase...
0
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...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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.