Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Enabling and disabling controls on a Continuous Subform in Access 2007/2010

I need to enable or disable a control on a continuous subform, dependent on another field. The initial code I wrote by instinct was very similar to what is suggested here, but instead of only disabling those controls which are marked as "child", it disables all of them - in effect, it seems only to be looking for the value of the last record and affecting all the rows.

Is there a way this can be achieved, or am I barking up the wrong tree? Code below:

If Me.Record_Type = "Child" Then 'Disable subsidiary records
Me.Record_Type.SetFocus
Me.Prospect_Name.Enabled = False
End If
like image 842
Sinister Beard Avatar asked Jul 16 '12 15:07

Sinister Beard


1 Answers

The only way of sensibly working with rows in a continuous form is with Conditional Formatting. Any code applied refers to the active row, and so it appears to affect all rows.

Conditional Formatting, Access 2010

Enable / Disable is selected

Conditional Formatting, Access 2010

like image 143
Fionnuala Avatar answered Sep 23 '22 19:09

Fionnuala