Get compile error: "expected: ="

[EagleOne]

2003

Using the following VBA Macro in Access:

Function Delete_Tables()
On Error GoTo Delete_Tables_Err

DoCmd.DeleteObject(acTable,"myTable")

Delete_Tables_Exit:
Exit Function

Delete_Tables_Err:
MsgBox Error$
Resume Delete_Tables_Exit

End Function

************************************************************************

PROBLEM: I get compile error "expected: =" error

HELP!!

TIA EagleOne

 

[Steve Schapel]

EagleOne,

Try it like this:
DoCmd.DeleteObject acTable, "myTable"

 

[EagleOne]

Thanks!