Easy- Using Built In Navigation Buttons 1

[luceze]

Is there a way to trigger an event, using the built in navigation buttons, when previous or next is clicked.

I am trying to make a field (TextBox) visible or invisible based on the value in another field (Yes/No). However, the field remains visible on every subsequent record until the Yes/No field is updated triggering its on update event.

I thought about creating my own navigation buttons, but it would be so much easier if I could just use the built in one.

Thanks,
Eric

 

[cghoga]

i'm not sure exactly what you need to do, but
have you tried putting your code in the On Current event property?

this may help. if not, let us know.

 

[luceze]

Thanks, that worked. I get confused sometimes where I need to put my code.

 

[janetlyn]

On your form's BeforeUpdate put

Private Sub Form_BeforeUpdate(Cancel As Integer)

Textbox.Visible = False

End Sub

"Textbox" needs to have your field name.

Try that and see if it helps. Janet Lyn