Hey,
I'm having a problem with my SQL statement and I'm not entirely sure what I did wrong. Does it not like spaces in a table name?
Intent of the form is for the admin to delete a record by selecting the GCAS (essentiallly a product/catalog #) they want to delete.
GCAS Table is a table
[GCAS ID] is the field name in the table
cbGCAS is a combo box in a subform where the user selects the GCAS to be deleted.
Code:
strSQL = "Delete * From GCAS Table Where [GCAS ID]=" & Forms!AdminFunctions!NSfAdminFunctions.Form!cbGCAS
Immediate window for ?strSQL
Code:
Delete * From GCAS Table Where [GCAS ID]=95128706
Error message:
The delete statement works elsewhere in my program so I'm not entirely sure why this one is giving me a problem
Thanks,
-Matt