Mutiple Appends!

[gojira999]

I have built a query that extracts data from a form and (in theory at least) appens the data to a table.

However......

When I run the query, the over generous application offers to append three rows!!!!!

If I select ok and run the query again it offers to append six rows!!!

I imagine I am overlooking something simple here - can you put me out of my misery?

Thanks.

 

[KenHigg]

Can you post your sql code?

kh

 

[gojira999]

It is as follows:

INSERT INTO medi_exp_details_table ( Discipline, [Regional Number], Name, Address, Postcode, Telephone, Fax, [E-mail] )
SELECT [forms]![mediexp_addnew_form]![1] AS Discipline, [forms]![mediexp_addnew_form]![2] AS reg, [forms]![mediexp_addnew_form]![3] AS nam, [forms]![mediexp_addnew_form]![4] AS [add], [forms]![mediexp_addnew_form]![5] AS pos, [forms]![mediexp_addnew_form]![6] AS tel, [forms]![mediexp_addnew_form]![7] AS fax, [forms]![mediexp_addnew_form]![8] AS ema
FROM medi_exp_details_table;

 

[KenHigg]

Was this a straight cut and paste? What code do you use to execute the query?

kh

 

[gojira999]

This was a straight cut & paste.

The query is being opened from design view.

 

[KenHigg]

This may be going around the long way to get a solution, but I would think that a form or control event related to the from that holds the data would need to fire the execution of the query?

Make sense?

kh

 

[sdebo2]

I don’t think you need the “FROM medi_exp_details_table” statement. All of your fields are should be coming from the form.

When tested this in one of my databases, I get duplicate records if there is a table showing in design view, but if I remove the table and only use fields from the open form, I get the results I think you want.