I have a command button to add a record to a query that is based on 3 different tables. Right now, as soon as I type something into the fields, it updates the table. Is there any way to make it not update them until the Add button is clicked? There is probably a simple answer that I am overlooking. Thanks for any help!!