Edit an Item from a ListBox ??

[Paul_birm]

Hi I have a Listbox on a form, i want to select (user to highlight a row) one of the list items and then click on a Button called 'Edit' to take the user to a form where they can edit the contents of the row.

can anybody help please?

do i need a docmd.openform (formname) and then put the UPDATE code in THAT form ??

cheers

 

[Adam Caramon]

do i need a docmd.openform (formname) and then put the UPDATE code in THAT form ??

That's a good way to do it. Take a look at this thread:
http://www.access-programmers.co.uk/forums/showthread.php?t=206376

 

[missinglinq]

Unless, of course, you're running Access 2007/2010, which has automated this process!

For these versions you can set the List Items Edit Form property of the combo box/lisbox and then simply right-click to edit/add to the items to the combo or list box.

Linq ;0)>

 

[darkstar257]

Unless, of course, you're running Access 2007/2010, which has automated this process!

For these versions you can set the List Items Edit Form property of the combo box/lisbox and then simply right-click to edit/add to the items to the combo or list box.

Linq ;0)>

Is there a way to program this for Access 2003???

 

[missinglinq]

Alas, no! For 2003 and earlier you'll have to do as you've already posited.

1. Open a form with the underlying Recordset as it RecordSource
2. Move to the appropriate record
3. Edit the record
4. Close this secondary form
5. Requery the Listbox