Changing Property of a Control

[RobertJohn]

Hi all

I have a button CmdPrevious and another button CmdNext. CmdPrevious is Not Visible. I want CmdPrevious to become Visible when I click CmdNext. I also want to move to the next record when I click CmdNext.

I can do the Next Record part using a macro, and I can do the Visible part using code. But I can't do both together! I am using Access 2007.

Can anyone help please?

Thanks

Robert

 

[Uncle Gizmo]

>>>I can do the Next Record part using a macro<<<

convert the macro into a function, (there is a utility in the MS access 2003 to do this I don't know if it has been maintained in access 2007)

and then add another line to this function :

Me.CmdPrevious.Visible = True

 

[RobertJohn]

Thanks

It worked fine.

Robert