Situation: I have a form that enables the user to select which TransActions will print on a report. The Accounting department sometimes makes mistakes so they sometimes have to do in and out transactions that really amount or net to zero.
So I created a form that has that entities transactions in it. When you double click on the list box it changes the value in the PrintRecord Field , yes or no, at the table level. The form also has a Total of all transactions box. This is actually a list box that has its row source set to a SQL statement in code that gets updated every time you tell a record to print yes / or no. It's value is only of the records set to print. I'm trying to get that value into a variable or an array and can't do it.
? How do I get the value of a listBox that is populated by SQL Statement to the its rowsource into a variable?
So I created a form that has that entities transactions in it. When you double click on the list box it changes the value in the PrintRecord Field , yes or no, at the table level. The form also has a Total of all transactions box. This is actually a list box that has its row source set to a SQL statement in code that gets updated every time you tell a record to print yes / or no. It's value is only of the records set to print. I'm trying to get that value into a variable or an array and can't do it.
? How do I get the value of a listBox that is populated by SQL Statement to the its rowsource into a variable?
