List box values in separate text boxes

[hockeyfan21]

Not sure if this is even possible but I am attempting it anyway.

I have Form1 with a listbox (lstView) that is populated from a combo box value - no problems there.

cboReport - User selects name of report
lstView - Populated in AfterUpdate of combo with list of "Views" the selected report has (Report by Size, Report by Color, Report by Month, etc.). Each report may have a different # of views & they are named differently.

Each "View" contains specific attributes or fields.

On Form2 I have 8 empty listboxes with an unbound text box above each. What I'm trying to do is, from Form1, select my command button, open Form2, and populate each text box with the name of the report views (Column(1) in my list box) by looping through lstView in Form1, then populate the associated field names for each in the empty listboxes.

I've figured out how to loop through, count and display the bound column just using a Debug.Print but not Column(1) yet.

Am I asking for the impossible??

Thanks for any point in the right direction - even som keywords to search on would be great!

Toni

 

[jdraw]

You might want to see some of Martin Green's tutorials
http://www.fontstuff.com/access/acctut19.htm