Delete multiple records in a subform

[gaker10]

So I guess my question is, can I compact the database from within the file via a button without using file paths?



When I click this button, I want the following to happen in order:

1. Delete everything from a specific table and it's form (refresh the form after the table data is deleted)
2. Compact and Repair the database

UPDATE:

I created a button to do step 1, but it is my understanding that a C&R cannot be done while VBA code is being executed, so coding this action would not be possible. For now I suppose I will use the Database Tools command to C&R upon request.

[June7]

Revisiting this code again and realized had to remove .MoveFirst line from the modified code in post 2 then it works perfectly. Not sure why it was in there.