validation for bank NO

[meezadahsra]

i have a db with the following table

std name (text field)(lookup fields)
std no (number)
bank ( yes/no)
bank no (number)

i have created a form to enter values into the table.

this is the problem

i want to allow users to enter values for bank no if BANK (yes/no) is yes
if its NO, then bank no. cannot be entered by users..preferably it should be grayed out.

i think this requires validation but i have no idea how to do it....

please help. thanks

 

[pbaldy]

One method:

http://www.baldyweb.com/ConditionalVisibility.htm