Best Way to Write Function 2

[LouieGrandie]

Have a field SelectionsYesNo which will a value of either Yes or No I want the following fields to be enabled if the value is Yes otherwise Disabled.

SelectionsOwner
SelectionsEstimatedTime
SelectionsEDC
SelectionsCompletedDate
SelectionsStartDate

I intend to put this statement on AfterUpdate on SelectionsYesNo. What is the best way to write that?


Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[PHV]

Me!SelectionsOwner.Ebabled = Me!SelectionsYesNo
Me!SelectionsEstimatedTime.Ebabled = Me!SelectionsYesNo
Me!SelectionsEDC.Ebabled = Me!SelectionsYesNo
Me!SelectionsCompletedDate.Ebabled = Me!SelectionsYesNo
Me!SelectionsStartDate.Ebabled = Me!SelectionsYesNo

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PGAC]

Hi LouieGrandie,


You could simplify using a WITH statement:

With Me
!SelectionsOwner.Enabled = !SelectionsYesNo
!SelectionsEstimatedTime.Enabled = !SelectionsYesNo
!SelectionsEDC.Enabled = !SelectionsYesNo
!SelectionsCompletedDate.Enabled = !SelectionsYesNo
!SelectionsStartDate.Enabled = !SelectionsYesNo
End With

 

[MichaelRed]

There is no real 'best way'. Endless opportunities. I would suggest adding a variable,

 Dim boolYesNo As boolean

 With Me
 boolYesNo = !SelectionsYesNo
 !SelectionsOwner.Enabled = boolYesNo
 !SelectionsEstimatedTime.Enabled = boolYesNo
 !SelectionsEDC.Enabled = boolYesNo
 !SelectionsCompletedDate.Enabled = boolYesNo
 !SelectionsStartDate.Enabled = boolYesNo
 End With

The minor advantage here is the minimizing references to the (form) variable !SelectionYesNo This may seem (ie) trivial here, but coluld be important is a larger scope.



MichaelRed