Data Browsing problem in an Auto-Incremented UDO-Form

I have an UDO form, whose Code value in master table should be automatically incremented.

So, when the user switches to ADD Mode, I find the next Code value with a query and update the related field on the form. ( SQl Select max (code) from .... etc )

Untill here everything is ok. When Add button is clicked, data is saved to database.

<b>BUT</b> when I navigate through the records using the Next and Previous buttons, that added record is not listed.

It exists in related table, since

1. I can see it in SQL Server.

2. It's listed with the details just as I entered, when I use <b>Find</b> button on the form <b>with "*"</b>.

<b>What may be the reason why these records aren't shown with prev & next buttons ?</b>