Disable enable

[neilmcmor]

Is it possible to have a form button disabled until a condition is true with other field values. I have a button, (appendbtn), that I want disabled until 2 fields, (Day) and (DayCheck) are equal.

 

[KenHigg]

Sure, put something like the following in the forms OnCurrent event:

if me!myControlName = "XXX"
   me.myButtonName.Enabled = false
else 
   me.myButtonName.Enabled = true
end if

 

[neilmcmor]

Its not working unles I switch it to design view and back. Could it be because the DayCheck field is unbound?

 

[neilmcmor]

Thanks I got it sorted now. Thanks for all your help, very much appreciated