I have a grid populated with a view of a table. I used the sql delete command to delete a record from the table and then requery the view and refreshed the grid but the record remained on the grid. If I close the form and open it back up the deleted record is gone. The record actually got deleted but you wouldn't know it until the form is closed and reopened. What am I doing wrong?

Thanks,
Dave