Ok, I might have managed to do that...

[qshaz]

Ok, I'm using (rather *copying* ) some code off from Microsofts sample, so I think I might have managed to do this...I'll update once I get it going (about moving the cirrent balance data autoamtically into the next record)...I now need to know how to stop the next record from automatically entering whenevr I add a new record in continious form view? The next record always comes up, ready and blank and that really confuses the users over here...any help would be much appreciated! Thanks!

 

[tomschafer]

You'll have to add this into your VBA code for the form, unless you never want to be able to add records then simply set the Allow Additions property of the form to no on the data tab...

Me.AllowAdditions = False