Try the following at the bottom of your add method:
lnRecNo = RecNo()
GO lnRecNo
* Sounds wierd, but I had a similar problem once and it worked.