Delete a single record by selection? 1

[Turb]

Hi all!
I have a Acc2000 database running with the main window hidden and all forms 'pop-up'.
I have one form, based on a query, that is giving me troubles with record deletion.

Before going to the hidden window setup, my users could simply use the 'record selecters' of the form and right click/cut to delete a specific record. This no longer works (selection seems to work, but the cut/copy/paste dialog is no longer visible).
Since going back to a non-hidden window is not an option, I was wondering if anyone could help me out.

How can I take an SQL statement, under a command button, like this partial one

DoCmd.RunSQL "DELETE * FROM LocTemp WHERE ItemNumber [b][blue]?????[/blue][/b];"

and make the 'where' statement indicate the selected record of the currently open form?
Something like this:

DoCmd.RunSQL "DELETE * FROM LocTemp WHERE ItemNumber = [Me]![[b][blue]SELECTED RECORD[/blue][/b]]

Thanks in advance!


- Turb

 

[PWise]

DoCmd.RunSQL "DELETE * FROM LocTemp WHERE ItemNumber =" &  [Me]![NameOfControlOfThePk]

 

[Turb]

pwise,
Thank you for your response!

Wouldn't this

DoCmd.RunSQL "DELETE * FROM LocTemp WHERE ItemNumber =" &  [Me]![ItemNumber]

want to delete ALL the records with the same "ItemNumber" showing on the form, not just a single selected record?


- Turb

 

[Turb]

I tried the code

DoCmd.RunSQL "DELETE * FROM LocTemp WHERE ItemNumber =" &  [Me]![ItemNumber]

and got an error stating "Microsoft Access can't find the field 'Me' referred to in your expression".
I also tried the code

DoCmd.RunSQL "DELETE * FROM LocTemp WHERE ItemNumber =" & [Forms]![ModifyPartLocation]![ItemNumber]

and got this error:
"Syntax error (missing operator) in query expression 'ItemNumber = 100.7520.24A'".

Thanks!


- Turb

 

[Turb]

Oh geez...
How this for ignorance:
Who needs a command button?
All the user has to do is click the recordselector of the record to delete and hit the 'delete' key on his/her keyboard!!!

*sigh*
Why is it we sometimes want make things so simple they're hard??

Thanks!


- Turb

 

[MajP]

DoCmd.RunCommand acCmdDeleteRecord

 

[PHV]

DoCmd.RunSQL "DELETE * FROM LocTemp WHERE ItemNumber=[!]'[/!]" & Forms!ModifyPartLocation!ItemNumber [!]& "'"[/!]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886