Hi,
I have recently been given a project at work which i will be starting soon and as a bit of forward palnning (dangerous i know) i am giving some thought as to how i will implement certain elements of it.
One such element is the production of a Compliancy Certificate, this will detail the regulations / standards that each particular product meets. Not every product will be required to meet the same Regulations / Standards since they are dependent on the construction, use etc.
I would like to avoid having the user type in all the relevant regs / standards for each product everytime they need to create a new record so i thought about perhaps using a multi-select List Box containing all the Regulations / standards. The user could then select the relevant regs / standards in the List Box, click a command button which would then pass these details to Text Box on a form. This form would then be the basis for the Compliancy Certificate.
I know how to set up the List Box and make it Multi-select but i am not sure if i can implement a Command Button to 'pass' the selected entries into a bound text form. So my questions are:
1. Can i use a List Box as outlined above?
2. How would i go about achieving the data transfer aspect?
3. Is the use of a List Box the most optimum method?
4. If not, recommendations welcome.
Regards
Alan
I have recently been given a project at work which i will be starting soon and as a bit of forward palnning (dangerous i know) i am giving some thought as to how i will implement certain elements of it.
One such element is the production of a Compliancy Certificate, this will detail the regulations / standards that each particular product meets. Not every product will be required to meet the same Regulations / Standards since they are dependent on the construction, use etc.
I would like to avoid having the user type in all the relevant regs / standards for each product everytime they need to create a new record so i thought about perhaps using a multi-select List Box containing all the Regulations / standards. The user could then select the relevant regs / standards in the List Box, click a command button which would then pass these details to Text Box on a form. This form would then be the basis for the Compliancy Certificate.
I know how to set up the List Box and make it Multi-select but i am not sure if i can implement a Command Button to 'pass' the selected entries into a bound text form. So my questions are:
1. Can i use a List Box as outlined above?
2. How would i go about achieving the data transfer aspect?
3. Is the use of a List Box the most optimum method?
4. If not, recommendations welcome.
Regards
Alan