How to use the AddItem method to transfer data from two fields into a single column in a listbox.
Q: Kris Rutko wants to know how to transfer data from two columns of table information into a single column in a listbox, using the AddItem method.
A: Save the value from each field to a variable of the appropriate data type, then concatenate these two variables into a String variable:
strItem = strStripNumber & ” (” & CStr(intAcreage) & “)”
Then use the strItem variable with the AddItem method to add it to the listbox’s list.