Hi!
You can disable an item in listbox only by adding "\" before the item text. This means that you can use AddItem("\"+lcText,...). When you have multiple columns, you have to do this for all columns to disable item. Unfortunately, there are 2 problems with this:
1. When you change the Enabled property value for combobox/listbox, all items will be disabled or enabled losing their original state.
2. No way to determine programmatically if item is disabled.
Because 2 things above, you require to store somewhere additional informationa bot which item is disabled. In your case, it is enough to remember what item was added to listbox just to show value of the field in ControlSource.
HTH.
>Hi Vlad,
>
>I already did the first option although the second one interests me. I tried to disable an item using DisableItem property but I just cant't get it right. Can you give me an idea on how to do it?
>
>Thanks...
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.