Delete Record Selected In Combobox

[a.sinatra]

delete reocrds from combo box

i cant del records from a combo box, its just selects the first in the combo box then it deletes it instead of deleting the one i clicked on, any help would be greatly appreciated! thank you
________
Mercedes-benz clk-class specifications

 

[WayneRyan]

asinatra,

Can't read it.

What version of Access is that? You'd be better off posting an
A97 or A2000 version.

Wayne

 

[a.sinatra]

alright access97 file, sorry before
________
Herbalaire vaporizer

 

[a.sinatra]

someone please help?
________
SEBRING (CONVERTIBLE)

 

[Mile-O]

The form you are using to delete stuff from is unbound so you can't simply delete the current record as it doesn't exist on that form.

All you are doing is putting a query into a combobox. This does not bind it to the form.

Your best bet, from what you seem to have, would be to use DAO to achieve what you want.


Also, I wouldn't advise using text fields as primary keys. i.e. Genre to Genre (in DVD table). It's always advisable to use an Autonumber as it takes up less space and memory.

And be wary of any code that says: DoCmd.DoMenuItem..... as that is obsolete code. Nowadays, we use DoCmd.RunCommand acCmd... syntax. You have the former example on your delete form.

 

[a.sinatra]

alright, i figured out how to use a delete query, but now how do i run that query silently in the background?
________
Dodge Demon Concept Specifications

 

[Mile-O]

If you run a delete Query silently, you need this code on your button's Click event.

DoCmd.SetWarnings False
DoCmd.OpenQuery "MyDeleteQuery"
DoCmd.SetWarnings True

 

[AngelicGuardian]

If you want I could post some pure code that would delete the record but it involves using the Database and Recordset Variables

 

[Mile-O]

If you want I could post some pure code that would delete the record but it involves using the Database and Recordset Variables

Along with using DAO and ADO, I was wondering if students, when they hand in projects such as this one, have to justify/explain the code.

If this is the case then it may be that RecordSet objects may be beyond the call of duty.

 

[a.sinatra]

Umm. Could you, im learning right now, and im still going to use my delete query cause thats what i know, but the code would be great
________
Z9

 

[Mile-O]

Umm. Could you, im learning right now, and im still going to use my delete query cause thats what i know, but the code would be great

Here's a link to explain Recordset objects, DAO, and ADO for you.