Unwanted Extra Record In Subform

[Dewi]

I have a continuous subform with allow additions set to false.
To make a new record I have used some update vba to create the record direct in the underlying query, then requery the form and the partly created record appears. The user then adds a quantity and some text. The subform still appears without the new record line.....However if I click the button again to create a second new record I end up getting an extra 2 lines. One is a duplicate of my previous one and a new blank record. These do not actually appear in the underlying table and the subform looks ok. However this extra record confuses the end user and I want to avoid it. Refresh or shift f9 does not eleviate the problem.Can anyone help?? Sometimes I even get two "current record" pointers.

 

[rzw0wr]

I am confused.
How can you have the form set to NOT have additions then add data?

Dale

 

[Dewi]

The form is set to AllowAdditions=false to avoid the "*" new record line at the bottom of the form. I then have 2 command buttons which depending on the user and the parent job status allows 2 types of records to be created with the fields populated accordingly through a DoCmd Run SQL update command. So the new records or "additions" are actually added to the underlying table. It was meant to be a neater trick than using the record creation and save functions of the form....

 

[JHB]

Could you post your database with some sample data, (zip it because you haven't post 10 post yet).