>This is a simplified example.
>
>I have a screen that displays the data from table1. There is a NEXT button on the screen that advances to the next record in table1. There is also a LOOKUP button that I want to disable and not allow to click based on the value of table1.region. If the region = '1' want to enable, otherwise disable. I know this should be easy, but it has been awhile since I have coded and this is taking me way to long.
>
>Thanks
>
>Brenda
Brenda
I presume you also have prev, first and last buttons. Whatever, in the click event of NEXT (and any other nav buttons) you can have a call to a method (or it can go in the click). The method checks on the region and enables/disables the LOOKUP button, e.g.
Thisform.cmdLookUp.enabled = ( REGION = "1")
HTH
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.