Help with a Access Form Listbox with VBA

[Y2KCobra]

Greetings to all

The problem I am having is I am desparetly trying to figure how to populate and retrieve data from a 3 column listbox. I would be greatful for a code example or a good point into the right direction.

Thank you in advance,

Steve

 

[TheAceMan1]

How are ya Y2KCobra . . .

WE HAVE NO Idea what you want until you be more specific!

See Ya! . . . . . .

 

[Y2KCobra]

lol... Picture a form with multiple list boxes.
1) Holds table field names
2) Will hold the headers from a read-in CSV file

User will select 1 for each to establish a mapping and add it to the mapping list box

Ex in Mapping box

[Col1] Department [Col2] <-> [Col3] CityDepartment]

Once the administrator maps all of the values in the 1) listbox and they click save I will need to extract all listbox rows/column data from the mapping listbox.

Does this help?

 

[Zion7]

Listboxes have a "column" property.
And an "ListIndex" Property.
And a "SElected" property
And A "ListCount" property
And an "Add" method,

Between these, you should be able to accomplish your desired task.

 

[TheAceMan1]

Have a look at the [blue]RowSource[/blue] property of the listbox . . .

See Ya! . . . . . .