Hello,
I created a program in which I use modules and classmodules for setting my
variables. For example when I need to set the customerID in a variable I use
something like: Object.Variables.Customers.CusomerID = ....
This works great and is similar in structure as for example the Docmd. or
me. structure.
Now I created a search form which can be opened from many forms, it consist
of only a listbox. The listbox is filled at startup. All necesery data I
keep in a table (row source, column withs etc). When I doubleclick on the
listitem I want a variable to be set. Instead of creating a long If..then.
structure, I want to keep the variables which needs to be set in my table.
So now I have a value in a table, which represents my variable. Is there a
way I can set the variable this way.
For example: I have a record in the table for a cusomter search. When I
doubleclick in the listbox I want the value in my table (which represents
the variable) to be set. So in the table is
"Object.Variables.Customers.CusomerID" (as a value) and the listbox gives a
customerID which needs to be matched to the
Object.Variables.Customers.CusomerID variable.
IS this possible???
Thanx,
Remco