July 5, 2009 02:43pm pdt

1. capricorn1 1,391,208
2. DatabaseMX 1,172,108
3. LSMCons... 822,525
4. boag2000 653,176
5. rockiroads 546,627
6. matthews... 482,961
7. peter57r 482,199
8. TextReport 425,769
9. tbsgadi 304,206
10. GRayL 257,824
11. puppydog... 217,464
12. mbizup 192,068
13. JDettman 185,878
14. cactus_d... 159,005
15. jimpen 147,628
16. mildurait 122,651
17. thenelson 119,917
18. LPurvis 108,250
19. dqmq 100,593
20. jmoss111 89,675
21. angelIII 78,190
22. hnasr 76,755
23. kelvinsparks 76,635
24. therealmo... 68,095
25. harfang 66,900

1. capricorn1 12,318,000
2. rockiroads 6,019,547
3. nico5038 5,704,781
4. DatabaseMX 5,514,962
5. LSMCons... 4,873,698
6. peter57r 4,753,665
7. LPurvis 3,570,290
8. shanesue... 3,288,317
9. harfang 3,171,339
10. GRayL 3,094,794
11. stevbe 2,861,511
12. jimhorn 2,807,017
13. boag2000 2,350,412
14. mbizup 2,322,560
15. matthews... 2,315,268
16. flavo 2,115,383
17. jadedata 1,968,277
18. jefftwilley 1,853,562
19. thenelson 1,820,286
20. puppydog... 1,666,822
21. cactus_d... 1,558,463
22. eghtebas 1,513,579
23. JDettman 1,332,393
24. dannywar... 1,327,637
25. Arthur_... 1,321,909

	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

11/23/2003 at 06:24AM PST, ID: 20806262

	[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!

7.8

Help with coding - Access 97

Asked by ohgee in Microsoft Access Database

Greetings

Am trying to create a linkage between two unrelated forms, i.e. the forms are not linked by any common fields. The database purpose is mainly to collect text in memo fields, grouped across three one-to-many tables. One topic can have many subtopics and each subtopic can have many articles headings. Each article is done in the memo field.

The MainInput form is used to choose the topic, subtopic and article heading, using drop down boxes. However if the user wants a heading that is not on the lists then its off to another form. The MainInput closes and the CreateNewTopics opens. The user creates the new heading/s and closes the form. This action then opens the MainInput again, but the MainInput opens blank. This is the problem. I need the MainInput to open at the same record it was at when it closed to go to the CreateNewTopics form.

I want the MainInput to close so that when it opens, it can see the changes that were made in the CreateNewTopics form. If there is another automatic way to refresh then will consider.

So I figure I need to create a variable that holds the value of the Topic control on the MainInput. Then before MainInput closes the variable value must be passed to another variable (because the first variable value will be lost when the form closes).
Then make MainInput open on the topic in the 2nd variable.

Have two challenges
Not sure where to place the various codes
Not sure how to write the code

Any help appreciated, especially where to place it.
Thanks

View the Solution FREE for 30 Days

20090429-EE-VQP-58

Help with coding - Access 97

Asked by ohgee in Microsoft Access Database

About this solution