We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Private Sub Form_Current() If Nz(DCount("ProjID", "tblFX", "ProjID= " & Nz(Me!ID.Value, 0)), 0) > 0 And DLookup("[HedgingStrategy]", "tblFX", "[ProjID] = " & Nz(Me!ID.Value, 0)) <> 3 Or 6 Then Me!cmdFX.ForeColor = vbRed Me!cmdFX.FontBold = True Me!BoxStatusFX.Visible = True Else Me!cmdFX.ForeColor = vbBlack 'of the current record of the form Me!cmdFX.FontBold = False Me!BoxStatusFX.Visible = False End If end sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|MS Access How To Run a Macro From Task Manager...Not With AutoExec...I Need To Call A Public Sub||3||49|
|Create a VBA Loop in Access to check records and create and action||7||55|
|Handle Apostrophes in VBA SQL - Part 2||10||48|
|Creating a filter on a subform MS access 2010||6||14|
Join the community of 500,000 technology professionals and ask your questions.