Hello,
sorry for my poor english. I'm a Frenchy ..

I have a Form to add, modify and delete table (ACCESS 2000).
I want to display a column of this table in a listBox.
With the VB 6 wizard, all columns are display in textfield.
The elements of the listbox must come from a parent table. The column is "type of treatment" and the types are store in a specific table (Id, Description).
The listbox must show the description and it's the id that is store in the table that is manage by my form.
I hope it's clear and thank you for jour help.

Hi

2 options, i can think of.
1. Use the MSForms listbox/combobox as it is like the one (exactly, in fact) used in Access, with columncount, columnwidths, etc.
2. Use a ListView and set the View property the Report. This will give you "hidden" columns by using the Tag property to hold the actual id of the record

Hope this helps
Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)