Query help

[Gazza2]

I have a query which contains four tables. There is a form based on the query and when i try to add a new record it will not allow me. i have a line of code (docmd.gotorecord,,acnewrec) on the afterupdate of the last textbox but it just takes me back to the beginning of the current record.

Any help is much appreciated

Gareth

 

[pbaldy]

Can you add a new record directly in the query? My guess would be not:

http://allenbrowne.com/ser-61.html

 

[Gazza2]

Ok i had a look at that page (very useful) but im not sure at the types of query.

I have attached a copy of an error i get if i use the form to update the query and also a picture of the query.