append query

stoneman · November 8th, 2003, 05:23 PM

I have a table that I want to add records to using an append query.
There are 4 fields to be added for each record and these fields are taken from another form.

The append query runs after the form is updated.

I build the append query in the query window and run it there.
The first time it adds one record as expected. If I dirty the form to fire the after update event (resave without change record) when the append query runs it add 3 records. Each successive run doubles the amount of record added...6, and 12, 24 and so on.

I also notice that if there is no record in the table it is not updated when the query runs.

How can I get aroubd these problems?

Thanks

sal · November 9th, 2003, 01:54 AM

I would have to see your append query code and table structure to figure it out

Sal

Steven · November 12th, 2003, 09:17 PM

Not too sure exactly what's going on without seeing yr code, but have you tried something like:

Code:

Private Sub Form_AfterUpdate()
If Me.Dirty=True Then
DoCmd.RunSQL "INSERT INTO BLAH BLAH BLAH"
End If
End Sub

Steven

I am a loud man with a very large hat. This means I am in charge