Hiding the autonumber field when blank 1

[perrymans]

I have a autonumber field as the Primary key. On a new record, the user sees (Autonumber). Once the first item is entered and the record is created, it is given an autonumber. How can I hide this autonumber txtBox until it has a value/ the record has been started?

I tried checking for a null value in the Autonumber txtBox using the Form_OnCurrent property, but this only fires after leaving the record.

I realize I could set this using the After Update of say the first control on the form, but this won't take into account that someone may skip to another control first.

Thanks. Sean.

 

[gol4]

use the beforeinsert and afterinsert properties on your form

 

[BGrego]

You could set the a control to have focus when a clean form is displayed, then call the onExit event on the field that you gave focus.

 

[perrymans]

Thanks guys. Neither really does what I had hoped for. I am going with the on_exit of the first control, and will just set it up so the user can't leave that control with selecting something (it's a combo box).

The beforeinsert/ afterinsert doesn't fire when the record is created, which is what I was looking for.

Thanks again. Sean.