November 18, 2008 10:35pm pst

1. LSMCons... 221,794
2. boag2000 207,288
3. capricorn1 173,245
4. DatabaseMX 113,861
5. peter57r 100,815
6. matthews... 61,295
7. harfang 55,490
8. jimhorn 51,658
9. jmoss111 46,537
10. GRayL 27,259
11. LennyGray 25,605
12. JDettman 25,023
13. hnasr 24,075
14. frankytee 18,250
15. MikeToole 16,650
16. RgGray3 15,896
17. kelvinsparks 15,490
18. mbizup 15,450
19. jefftwilley 15,400
20. wiswalld 14,660
21. dqmq 13,287
22. Arthur_... 12,882
23. clarkscott 12,710
24. nexusnation 12,400
25. cactus_d... 12,394

1. LSMCons... 286,909
2. capricorn1 216,253
3. boag2000 215,263
4. DatabaseMX 189,219
5. peter57r 143,269
6. matthews... 89,629
7. jimhorn 75,676
8. harfang 74,470
9. jefftwilley 61,168
10. jmoss111 51,137
11. GRayL 47,691
12. JDettman 45,298
13. frankytee 35,142
14. mbizup 31,050
15. MikeToole 30,650
16. dqmq 29,647
17. LennyGray 25,605
18. kelvinsparks 24,990
19. hnasr 24,075
20. stevbe 21,852
21. puppydog... 21,045
22. LPurvis 20,873
23. rockiroads 19,250
24. Arthur_... 16,982
25. wiswalld 16,390

10.07.2008 at 03:33PM PDT, ID: 23795619

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

6.4

Can I create a dynamic table as a list within a subform?

Asked by Dominator1025 in Access Architecture/Design, Microsoft Access Database, Access Forms

Hello,

I have created a form. A record in my form contains all of the general information(name, address, phone #, Entity #) about one of my many business entities. I am trying to create a sub-form that has 4 columns(Account, Description, Included, Entity #) that shows a listing of all of the possible revenue accounts that an entity may have. "Description" describes the account. "Included" is a check box that indicates whether the entity includes the account in their revenue calculation, and "Entity #" is the key between the master form and sub form.

I would like to bring up an entity in my main form and then show the list of all 100 of the possible revenue accounts in the sub form. The 100 accounts are the same for every entity shown in each record of the main form. I would like to see all 100 accounts at the same time in the sub form for each entity. I would then like to be able to check the check box if the entity includes the account. My vision is that by checking the box, the user would be creating the record in the table shown in the sub-form. Checking the box would also automatically input the Entity # in the sub form as it appears in the master form.

Can this be done?

Thanks!Start Free Trial

Keywords: Can I create a dynamic table as a list w…

	Title
1	Calculate revenue (CPM) from page i…
2	Revenue Calculator - Multiple Values
3	Revenue projections. Adsense or like…
4	No calculations in Report subform
5	Daily Revenue Average
6	subform total gives error when no rec…

Loading Advertisement...

20081112-EE-VQP-44 / EE_QW_2_20070628

Can I create a dynamic table as a list within a subform?

Asked by Dominator1025 in Access Architecture/Design, Microsoft Access Database, Access Forms

About this solution