What is the 'proper' way to delete a bunch of records, using a form? (and VB) Basicly go through all the records and if date = xxxx then delete record. The best way I have right now is running through all records with code, then using docmd.RunCommand.DeleteRecord. If there's a better command available please let me know. querys perhaps? I can make it happen but is it the most efficent? Thanks for any suggestions

If you want to delete a number of records at one time then a delete query would seem to me to be most practical.