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

SubForms Not working properly

100+
P: 166
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
Share this Question
Share on Google+
1 Reply


JustJim
Expert 100+
P: 407
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

Post your reply

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