VBAhole22
Registered User.
- Local time
- Today, 02:19
- Joined
- Jan 18, 2002
- Messages
- 117
I have an application that is basically one form and one table. A user selects a location on the form and 5 "metrics" are run. A metric is simply a scoring system based on the things present, or absent, at that location. There are 5 different metrics and each time a location is selected all 5 are calculated and a total score is produced. Here is my question: what is the best way to store the scores that I display on the form? Each metric is an a different sub procedure that get called in the code on the form. The way I see it there are 2 or 3 ways. i)I could name all 6 (including the total score) as public variables and have them tally that way. or ii) I could just have the procedure put the score on the form and then I have it there to toal up. Does it matter either way?