MS VBA Access: How to Delete "One" Record in a Table

[davidelloyd]

I keep getting this error: "Syntax Error In From Clause."
The below is my code. Could someone help.

Private Sub Command26_Click ()
DoCmd.RunSQL "DELETE * " & _
"FROM Budget_Planner_ SubDatasheet" & _
"CompanySto re = 'Begining Balance';"

[janders468]

You are not signifying your where clause as a where clause it should read:

DoCmd.RunSQL "DELETE * FROM Budget_Planner_SubDatasheet WHERE CompanyStore = 'Begining Balance';"