Creating a new record.

[Adrian Brown]

Is there an easy way of creating a new record when a user presses a button
(Add Item) but not by scrolling through the records using page up / down /
mouse wheel. Ive turned off allowadditions currently turn it on, do
Recordset.AddNew and tun allowadditions off again when the button is
pressed, but im having alot of problem getting the form to update everything
to the new record - i presume i need to set the bookmark, but i cant work
out what i need to set it too.

Many Thanks

 

[Adrian Brown]

Oh, i should have also mentioned that I currently have a 'Save this record'
message when you try and move to a different record. I want it to not save
the record at all if you say no when that appears if you have just created
it. Basically if you click Add Item then move of the record it should say
Save this record - if you click no it should discard the entire record.