martinrobson
Programmer
Hi, please can you help?
I currently have a form which contains a list box, listing all the records in my database tables. I would like to be able to delete a record from the table using the listbox to hughlight it and a delete button to delete it.
I have tried a few different methods which i thought should work but havent managed it. It will get complicated as i need to think about foreign keys, but can someone give me the basic code i would need to allow this.
I have the ablility to ammend records from the listbox at the moment, so know how to get the selected item displayed, but would like to be able to delete rather than disply, if that makes sense.
Thanks in advance for your time.
Martin
I currently have a form which contains a list box, listing all the records in my database tables. I would like to be able to delete a record from the table using the listbox to hughlight it and a delete button to delete it.
I have tried a few different methods which i thought should work but havent managed it. It will get complicated as i need to think about foreign keys, but can someone give me the basic code i would need to allow this.
I have the ablility to ammend records from the listbox at the moment, so know how to get the selected item displayed, but would like to be able to delete rather than disply, if that makes sense.
Thanks in advance for your time.
Martin