How to remove record from specific table? (1 Viewer)

I have a one-to-one relationship between Profile_ID and Time_ID

I have a form where i want a button to delete the record in Time_Table
But keep the record in Profile_Table.

What VBA code to put on a button to delete the record in Time_Form where i display data from both Profile_Table and Time_Table.

Along the lines of:

CurrentDb.Execute "DELETE * FROM Time_Table WHERE Time_ID = " & Me.Time_ID