Delete specific entry in table - only entry in row A column B

[Riun]

when I use the following code:

Dim stDocName as String
stDocName = "DELETE FROM [Tenor Drop Down] WHERE [ID]=" & txtID
DoCmd.RunSQL stDocName
 

the whole row will be deleted from the table. I only want the specific record to be deleted - the entry in the row that is in column [Tenor1].

I tried to use

 
Dim stDocName as String
stDocName = "DELETE [Tenor1] FROM [Tenor Drop Down] WHERE [ID]=" & txtID
DoCmd.RunSQL stDocName
 

in order to only delete the entry in the row that is in the specific column [Tenor1]. it doesn't work.

Any suggestions, please?

[iburyak]

Try this:

[PHP]stDocName = "UPDATE [Tenor Drop Down] SET [Tenor1] = """" WHERE [ID]=" & txtID
DoCmd.RunSQL stDocName[/PHP]

[Riun]

Thank you very much, Urbanangel! it works. now I only need a way to cut the rest of the entries and paste them on entry higher, so that there is not an empty entry. will I be needing a loop?

[NeoPa]

Riun, If you post your table structure and explain what you're trying to do and why, we can look at alternative approaches. What you're suggesting sounds like something you wouldn't want to do in an RDBMS. There is probably a much more straightforward way to handle it but I suspect it will mean rearranging your data structure.