Quote Originally Posted by Imdabaum
For this kind of functionality, you'll want to use the OnCurrent event.

In the code you'll want to check

[VBA]
SELECT Case Me.cboActivity.Value
Case 1:
Me.yoursubformname.txtStartDepth.enabled =True
Me.yoursubformname.txtEndDepth.Enabled=True
Case 2:
' enable other controls
Case 3:
' enable other controls
Case Else
' disable all controls. Me.subformname.Controlname.enabled = false
[/VBA]
A Select Case block seems the right approach. But those Case statements won't work. The OP list sample activity code values as 1.1, 1.2, 1.3 ...
None of those will match Case 1

If cboActivity.Value is numeric, use:

[VBA]Select Case Int(Me.cboActivity.Value)[/VBA]

If cboActivity.Value is a string, use:

[VBA]Select Case Left(Me.cboActivity.Value, 1)
Case "1"
Case "2"[/VBA]

(No colons after Case statements.)

In addition to doing this for On Current, I think he may need to do it for cboActivity After Update.