Enabling of Buttons on a form

[DazedandMuddled]

Quick question (and probably very simple )

on a form how can i disable a button when i move to another record.

ie. the button is named btnName

the function of it is to execute the command

DoCmd.GoToRecord , , acNewRec

obviously this opens another record but the button is still enabled how do i disable it -is it on the onload or afterupdate element of the form??

Thanks
Cam

 

[FoFa]

I think it is the form's On Current event you want. This event is activated when you move to a new record, or the form is refreshed.

 

[mousemat]

add the following code after

DoCmd.GoToRecord , , acNewRec

btnname.visible = false

 

[DazedandMuddled]

add the following code after

DoCmd.GoToRecord , , acNewRec

btnname.visible = false

.visible won't work as this will hide the button, i want to disable it (grey out the text on the button)

FoFa - i'll try the on current and see what happens! Tx

 

[mousemat]

btnname.enabled = false

 

[DazedandMuddled]

I think it is the form's On Current event you want. This event is activated when you move to a new record, or the form is refreshed.

excellent - just where its meant to go

Thanks FoFa

mousemat sorry if that answer appeared short - wasn't meant to!