[X]My Assistant

[rzw0wr]

I copied this SQL from a Delete query.

In VB I want to select a record to delete from a table.

I get an error about an operator missing in the where part.


 Error.png ( 64.21K )Number of downloads: 0




DeleteSQL = "DELETE tblPartMaterialList.tblPartMaterialList_ID, tblPartMaterialList.PartMaterialList " & _
"FROM tblPartMaterialList " & _
"WHERE (((tblPartMaterialList.PartMaterialList) ))= " & Me.MaintList

Thank you,
Dale

[MadPiet]

Isn't the syntax

DELETE
FROM MyTable
WHERE ….

Specifying columns in the DELETE statement doesn't make sense, because you're deleting the entire record. If you want to just "delete" the contents of certain rows, use an UPDATE statement

UPDATE MyTable
SET Field = Null
WHERE …

[rzw0wr]

Wouldn't that leave an empty record?

[FrankRuperto]

If you want to delete the record, then use:

CODE

DELETE FROM tblPartMaterialList WHERE tblPartMaterialList.PartMaterialList = Me.MaintList

You can only specify one table to delete from in the SQL statement.

[RJD]

Hi: Given that the contents of Me.MaintList looks like text, you might try something like this ...

DeleteSQL = "DELETE * FROM tblPartMaterialList WHERE PartMaterialList= '" & Me.MaintList & "';"

But this raises the question about what is contained in the field PartMaterialList. Is this really a list? Do you want to delete any record that contains the text found anywhere in Me.MaintList? Or is this really an = match?

HTH
Joe

[orange999]

Dale,

What exactly is in Me.MaintList? A sample will help readers to provide more focused advice.

[rzw0wr]

Thank you for the replies.

I found that I did not need an SQL statement after all.


I had my form list combo set to the wrong data.


Dale