A
Adamaths
Hi,
I've hit a wall with a model I am currently building. It is a data
collection system for several metrics each of which has a different
number of componenets.
I have several data entry forms, one for each possible number of
components for a metric. They are named:
frm3PartDataEntry
frm4PartDataEntry etc..
The problem comes when I wish to show them. The user is selecting a
metric from a list box and hitting an enter data button. When they do
this I look up the number of components the metric they have selected
has and store this in a public variable NumberOfComponents.
I had hoped that to show the form, the following code would work:
frm & NumberOfComponents & PartDataEntry.Show
Sadly it won't compile, and aside from writing a horrible Select Case
I'm stumped as to what to do.
Any advice would be greatly appreciated.
Thanks in advance,
Adam
I've hit a wall with a model I am currently building. It is a data
collection system for several metrics each of which has a different
number of componenets.
I have several data entry forms, one for each possible number of
components for a metric. They are named:
frm3PartDataEntry
frm4PartDataEntry etc..
The problem comes when I wish to show them. The user is selecting a
metric from a list box and hitting an enter data button. When they do
this I look up the number of components the metric they have selected
has and store this in a public variable NumberOfComponents.
I had hoped that to show the form, the following code would work:
frm & NumberOfComponents & PartDataEntry.Show
Sadly it won't compile, and aside from writing a horrible Select Case
I'm stumped as to what to do.
Any advice would be greatly appreciated.
Thanks in advance,
Adam