1

I have a form with a subform in datasheet view, 2 fields Im working with are 'completed' and 'activity'. On the form open or load, how can I set 'activit'y for each line in the subform to enabled / disabled depending on whether 'completed' = Y or N? Any hint appreciated

thanks

DarkW1nter
  • 2,933
  • 11
  • 67
  • 120

1 Answers1

3

You can use conditional formatting for continuous forms and datasheets.

enter image description here

Fionnuala
  • 90,370
  • 7
  • 114
  • 152
  • Doesn't this just set the colour etc of the field? Not the other properties such as locked, enabled etc – DarkW1nter Sep 06 '12 at 11:09
  • 1
    Observe the clicked button beside the text (A) button. It is the enable / disable button. See also http://stackoverflow.com/questions/11507151/enabling-and-disabling-controls-on-a-continuous-subform-in-access-2007/11507179#11507179 – Fionnuala Sep 06 '12 at 11:11