[AccessD] Disabling an Option Group

Rocky Smolin rockysmolin2 at gmail.com
Sun Jan 14 15:18:54 CST 2024


I tried

Private Sub Detail_Paint()
    If Me.fldTenantLeaseStepHeading = True Then
Me.fldTenantLeaseStepUrgency.Enabled = False ELSE
Me.fldTenantLeaseStepUrgency.Enabled = True
End Sub

I turned the option group control in all the record to disabled, and then
errors that it couldn't find fldTenantLeaseStepHeading.

r

On Sun, Jan 14, 2024 at 12:37 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> Godd call.
> You always need a construct such as
>
> Private Sub Detail_Paint()
>     If Num1 = 6 Then
>         Text3.BackColor = &H666666
>     Else
>         Text3.BackColor = &HFFFFFF
>     End If
> End Sub
>
> when doing something with individualn rows in a continuous form or report.
> to avoid incorrect results.
>
>
> On 14 Jan 2024 at 14:18, John Colby wrote:
>
> > Rocky, is the field true for every record?  It feels like there should
> > be an else which sets enabled to true.
> >
> > Did you watch the youtube video for that part where the presenter
> > discussed what he was doing.
> >
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list