I have a form and when you click a specific label another form opens. This second form has a drop down box that you can select items from. Based off the selection a list box is populated with information from a query (that gets its data from the drop box and using requery) that has three fields. When I select an item from this list box I want to pass ALL of that information to the first form in a text or memo box. I am only able to pass one of the fields from that list box because of the Bound Column property. I can not find anywhere that allows it to be set to anything but one specific column.
I attempted to write code that would change that and assign the values to a global variable that I could pass to the first form with no luck.
I am at a loss for what to do now.
Any help that someone can pass along would be greatly appriciated.
--Jason