Hi All

I've was wondering if it is possible to set value in an unbound textbox from double clicking in a listbox.
The listbox has 6 columns and I want to set value in 3 textboxes from 3 of the columns in the listbox.

Any help is highly appreciated.

Thanks / Fred

Set the Control source for the textboxes to be:
etc





I am a loud man with a very large hat. This means I am in charge

To my fellow Australian,

Thank you so much, I had a feeling it would be something simple like that.
I tried something similar, but my shortcomings in VBA unabled me to add the brackets and the dot.

Cheers / Fred