Access/Append Query/Problem

[Reety]

Hello guys, back again with another problem...



when ever i put data into the 'booking screen' and then run the 'append query' it creates the record but 5 of them, now what i have found out was, the amount of records in my viewings table (this is the place where the new records go to using the append query) accounts for how many append queries will be created. Therefore if there are 5 records in my viewings table then 5 append queries will be created using the booking screen form, if 10 records are in my viewings table then, 10 append queries will be created and so forth, i cannot identify where this problem lies.

Thank you for your time and assistance


Reety.

[June7]

Your image is not showing.

Post the SQL of the append query.

[Reety]

http://i.imgur.com/a0fhZsQ.png

go to that link, does it work?

[June7]

Probably, but I am blocked. I will have to try tonight. However, doubt it will be helpful unless it shows the SQL statement.

[Reety]

what is the SQL statement?

[June7]

Open query, switch to SQL View.