Form Validation Question 1

[lcutliffe]

Hi
Im working on a form in Microsoft Access 2003. This particular form has a combination of about 25 text boxes and combo boxes and two buttons at the bottom. One button leads to another form and I have it disabled when the form loads. I need it to become enabled when all the fields have been filled in the form. I am not sure where to put the code or what method I should use to make this work. Any help would be appreciated.

 

[PWise]

one way in the after update of each text box check

if me.text1>"" and me.text2>"" and mecombo1>"" ....then

me.button.enabled=true
end if

but rather then check after the update of each (25)controls

have the button enabled and in the onclock event
[/code]
if not (me.text1>"" and me.text2>"" and mecombo1>"" ....) then exit sub
[/code]

 

[PWise]

sorry sb onclick not onclock