Hi Hansup,

It seems that the process is to reinitialise thecontrols to not enabled before you check for the cboActivity value and then set the appropriate controls enabled (as outlined in the below code).

Can you confirm that Fix() works on a text value.


[vba]
Private Sub Form_Current()

Me.txtStartDepth.Enabled = False
Me.txtEndDepth.Enabled = False
Me.txtQuantity.Enabled = False

Select Case Fix(Me.cboAct.Value)
Case "1"
Me.txtStartDepth.Enabled = True
Me.txtEndDepth.Enabled = True
Case "2"
Me.txtQuantity.Enabled = True
Case Else
Me.txtStartDepth.Enabled = False
Me.txtEndDepth.Enabled = False
Me.txtQuantity.Enabled = False
End Select
End Sub [/vba]

Thanks for the link. Will read with interest.

Are there any adequate resources that can assist with deploying the database into a multi user environment?