Record Navigation Buttons Appear/Disappear

[samjh]

hi,

I have record navigation control buttons on my form, but if I am at the First Record, I don't want the Previous button to be visible, and equaly if I am at the last record I don't want the Next button to be visible.

Could someone let me know how you go about doing this please?
thanks

the code is written below:

Private Sub Command13_Click()
On Error GoTo Err_Command13_Click

DoCmd.GoToRecord , , acNext
Exit_Command13_Click:
Exit Sub
Err_Command13_Click:
MsgBox Err.Description
Resume Exit_Command13_Click

End Sub

 

[gemma-the-husky]

personally, i would make the inoperative buttons disabled rather than not visible. I think it is a better effect for users.