Class Module - maybe

A real begineer

Registered User.
Local time
Today, 02:33
Joined
Nov 4, 2000
Messages
74
Look all you genius' I don;t get this, but I think it is the solution I am after. I will try and explain what I am trying to do.

I have a table, for simplicity we will call this table1. In this table are several fields which hold various items of information which are called by my main application - repeatedly.

For example one of these fields, we will call colour. Colour is called upto 20 times when the main application crunches the numbers.

From what I have read I should be able to lookup this vaule in a class module and then refer to the class module instead only looking up once instead of repeatedly.

I guess my questions are:
Am I on the right track?
How does this work?
 
Wouldn't it be easier to look it up once, store it in a variable, then use the variable in the equation?
 

Users who are viewing this thread

Back
Top Bottom