Use variable in sql

[Alex]

If I use the code below, records are deleted from my table if I replace
tblModel with the name of a real table. However, I need to use a table
variable instead. I've set it with tblModel, which gives the correct table
name, but it doesn't work within my RunSQL. Any ideas how I can use a table
variable? Thanks much.


Private Sub Command4_Click


tblModel = "Export" & [Forms]![Export_Ref_Parts]![ModelToImport]

DoCmd.RunSQL "Delete tblModel WHERE ((([Part#]) Is Null));"


End Sub

 

[Douglas J. Steele]

DoCmd.RunSQL "Delete " & tblModel & " WHERE ((([Part#]) Is Null));"

 

[david epsom dot com dot au]

Waiting for trouble using # in a field or table name, because # is also
sometimes used as an alias for . dot. Expect trouble just when you least
expect it.

(david)