edit listbox question

[ajking]

I have a database which has a listbox where you can select a name from the list. this name is placed in a text box and what I want to be able to do is: edit the name and replace the corresponding record with the new name i.e. delete the old name and replace it with the new name. I don't want to add it as a new record. TIA

'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980

 

[Remou]

It should be possible to run an Update query in code, for example:

Dim db As DAO.Database
Set db=CurrentDB
strSQL="Update tblNames Set [Name]='" & Me.txtName _
& "' Where ID=" & Me.lstNames
db.Execute strSQL, dbFailOnError

 

[ajking]

Hi Remou
many thanks for superfast reply. I will try it out asap

'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980