Event for add-record nav button

[MikeAngelastro]

Hi,

I have a form in which I a Key field - Year. I lock the field to prevent crytic error messages from Access. However, when the user presses the add-record navigation button, I want to unlock this field. But I can't figure out what event occurs when the user clicks this button. Any help?

Mike

 

[Travis]

Try the Current Event

Then check if Me.NewRecord = True

or

BeforeInsert Event or AfterInsert Event

[This message has been edited by Travis (edited 10-12-2001).]

 

[MikeAngelastro]

Thanks Travis.

Your advice worked very well.