Add a Record with Button

DeeDee77

Registered User.
Local time
Today, 20:23
Joined
Jan 24, 2002
Messages
21
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!!
 
When you say "I have a command button to add a record to a query", do you mean that you have a command button to add a record to a table that uses a query based on 3 other tables??

If so, why don't you just open a recordset to add the record?
 
By the time the command button is clicked, the fields that have been entered in on the form have already updated the tables.
 
Ok, I'm going to guess that the fields on the form are bound to the table, which will explain why the table is being updated before getting to the command button. What you might want to look at doing is having the form unbound. This way, you can type information in the fields and then click the command button to save the record. To save the record from an unbound form you will need to open a recordset. If your not sure how to do this let me know.
 
I fixed it by not setting the RecordSource on the form to anything. Thanks!!
 

Users who are viewing this thread

Back
Top Bottom