Select item from ListBox

[eugz]

Hi ALL.
I have MS Access form with 2 buttons. By click those buttons user can open other form which has ListBox. I have a problem to select item form ListBox and Add or Delete it to the table.
I appreciate any help.

 

[WayneRyan]

eugz,

This is a broad topic!

Don't know exactly how you want to add something to a table that's not in
a listbox. Is it multi-column? How do they select when they want to delete?

For deleting:

DoCmd.RunSql "Delete From SomeTable Where TheKey = " & Me.Listbox

That at least gets us started ...

Wayne

 

[eugz]

Hi. Thanks for response
Here is my scenario. I have a 1 column listbox(class) in a form(frmClass). The listbox is populated by a Table(tblClass). It displays the TypeClass. I want to be able to get the information of the currently selected item and double-click in the listbox and automatically update another table(Process) which has ClassID field of tblClass. My problem is update tblProcess by selected row in the listbox.
Any help with this would be appreciated. Thanks in advance.