change listbox item with double click

[msasan1367]

I want to double click on one of listbox item and change it without opening any other form. is it possible?
thanks

 

[pbaldy]

Probably, but it would help to know what you want to do. If you need user input you could use an InputBox.

 

[msasan1367]

Probably, but it would help to know what you want to do. If you need user input you could use an InputBox.

I have a list of name in this list box and want to change each name with double click on it

 

[pbaldy]

Well, presuming the listbox is based on a table (row source) you can open a recordset or execute an update query, either way using the key field from the listbox as a criteria.

 

[msasan1367]

Well, presuming the listbox is based on a table (row source) you can open a recordset or execute an update query, either way using the key field from the listbox as a criteria.

but I want to edit listbox without opening another form just double click on and it becomes editable

 

[pbaldy]

Oh, edit directly in the listbox? I don't think that's possible.

 

[smig]

If listBox is based on table or query I guess you cant.
I guess you can if it is based on values list.