Edit record in list box by double clicking

[xcmav66]

I want to write some code that will change the state of a parameter for a record in a table if I double click on it in the list box. How can I do this?

 

[xcmav66]

I tried binding the 1st column of the list box (which is populate from a query) to the control, but I still don't know what commands to use to specifically edit a parameter of that record.

 

[xcmav66]

bump...anyone?

 

[MrGrumpy]

Can someone please help here? I need the same information. I am creating a visitor database, which clocks contractors etc in and out of our facility. I would like to change the status from "clocked in" to "clocked out" by double clicking their name in a list box.

 

[gemma-the-husky]

you would need to use a sql statement something like

update employeetable set status = whatever where employeeid = listboxvalue

you do this by

docmd.runsql statement
or currentdb.execute statement

the statement has to be formatted properly or it will not work

after executing the statement then

listbox.requery will requery the listbox contents (if you are displaying the logged in status.

---------
note that you cant update the listbox directly - the listbox is drawn from a query, and therefore you have to amend the table(s) which underly the query to affect the lsit box.