Adi
03-31-2001, 11:58 AM
Hello Guys,
I've got this program where i select a value from one list box on Microsoft Access and, clicking a button, i transfer that value to another list box.
so far so good. unfortunately, i use Access Queries to accomplish this but it takes a LONG time to run for each value! i was thinking of speeding the process up by using VBA but i'm at a loss at how to do it. i have to remmember i need to add the value to a table of my choice.
even Worse! how can i select more than one value and transfer it? and how about telling the first list the value was already selected without running a duplicate check on the second list?
sorry for all these questions but it does get frustrating.
hope you can help. thanks
I've got this program where i select a value from one list box on Microsoft Access and, clicking a button, i transfer that value to another list box.
so far so good. unfortunately, i use Access Queries to accomplish this but it takes a LONG time to run for each value! i was thinking of speeding the process up by using VBA but i'm at a loss at how to do it. i have to remmember i need to add the value to a table of my choice.
even Worse! how can i select more than one value and transfer it? and how about telling the first list the value was already selected without running a duplicate check on the second list?
sorry for all these questions but it does get frustrating.
hope you can help. thanks