R
Richard Buttrey
I'm designing a relatively simple order application using VBA forms
etc., whereby the user selects a component product code from a drop
down list. This returns a descriptive text string which is added as
the next line on an order template.
However for some codes, the associated descriptive text needs some
additional information included.
e.g.
CodeABC1 Upright Position Offset 600mm from rear
where the '600mm' is a variable number and could come from a list of
values associated with this particular code, and only this code.
One way would be to expand the list of codes so that every particular
permutation was a unique code but I'd like to avoid that
I suspect I need another listbox which needs to become available when
a code which needs addtional information is chosen.
One complicating factor is that for some codes there may be more than
one additional, and different set of values, that need to be included
elswhere in the product description text.
Can anyone suggest a VBA coding technique for handling this
requirement, which is essentially building up a fuller description
from a base description. I could add to the database a field which
identifies how many additional pieces of information are required if
that helps the coding. The position of the additional values in the
basic text string will also vary from code to code.
Values additional to those codes which require additions are unique to
the code in question. Which means that it is probably not appropriate
to just have a single list of all additional values to the base text.
Hope I've explained the basic problem. I'm not looking for specific
VBA coding, but ideas as to how to handle the capture of the
appropriate data through form objects.
Any other ideas or suggestions would of course be welcome.
Kind regards
Richard Buttrey
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
etc., whereby the user selects a component product code from a drop
down list. This returns a descriptive text string which is added as
the next line on an order template.
However for some codes, the associated descriptive text needs some
additional information included.
e.g.
CodeABC1 Upright Position Offset 600mm from rear
where the '600mm' is a variable number and could come from a list of
values associated with this particular code, and only this code.
One way would be to expand the list of codes so that every particular
permutation was a unique code but I'd like to avoid that
I suspect I need another listbox which needs to become available when
a code which needs addtional information is chosen.
One complicating factor is that for some codes there may be more than
one additional, and different set of values, that need to be included
elswhere in the product description text.
Can anyone suggest a VBA coding technique for handling this
requirement, which is essentially building up a fuller description
from a base description. I could add to the database a field which
identifies how many additional pieces of information are required if
that helps the coding. The position of the additional values in the
basic text string will also vary from code to code.
Values additional to those codes which require additions are unique to
the code in question. Which means that it is probably not appropriate
to just have a single list of all additional values to the base text.
Hope I've explained the basic problem. I'm not looking for specific
VBA coding, but ideas as to how to handle the capture of the
appropriate data through form objects.
Any other ideas or suggestions would of course be welcome.
Kind regards
Richard Buttrey
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________