I have a form that users enter information in that updates a block of records. I would like to clear all the fields after the query runs and updates the records so that another block of records can be updated without having to close the form or erase the fields one by one. Can anyone help with this?

Hi

Why don't you try using the requery function and use this in the event after update. You can do this by creating a macro and selecting requery.

HTH