Trouble with conditional formatting

[jjake]

Hello,

I am currently using the following code in VBA to disable/enable a text box.

DLookUp("[Department]","[tblUsers]","[UserTag]='" & [Me].[txtUser] & "'")=2

I have tried using this same expression in conditional formatting to enable a different box but it isn't working. Any idea why?

 

[bastanu]

Conditional formatting cannot disable a box, it simply changes the formatting. Try it without Me like:
DLookUp("[Department]","[tblUsers]","[UserTag]='" & [txtUser] & "'")=2

Cheers,
Vlad

 

[isladogs]

You can easily do this in code

if DLookUp("[Department]","[tblUsers]","[UserTag]='" & [txtUser] & "'")=2 Then
Me.othertextboxname.Enabled=True
End If

Use this code in a suitable procedure e.g. The after update event of txtUser control

 

[jjake]

Ridders, i currently have this textbox using conditional formatting to enable/disable using the following expression

[RDReview]=1 And [ProductionReview]=1 And [MaintenanceReview]=1 And [SafetyReview]=1 And [SiteManagerReview]=1

How would i combine this with the code you provided?

 

[isladogs]

Just combine them like this

if DLookUp("[Department]","[tblUsers]","[UserTag]='" & [txtUser] & "'")=2 And [RDReview]=1 And [ProductionReview]=1 And [MaintenanceReview]=1 And [SafetyReview]=1 And [SiteManagerReview]=1 Then
     Me.othertextboxname.Enabled=True
End If

 

[June7]

@bastanu, yes ConditionalFormatting can enable/disable.

I agree that Me. must be removed from the ConditionalFormatting expression.

Me. and Me! only work in VBA.