![]() ![]() I am fairly confident the issue is from combining multiple If/Dlookup functions consecutively. The code is not throwing any errors, but is not resulting in the expected behavior. ![]() StrMessage = "Change fourth digit - HWCI/BL has been certified." If DLookup("GWSHW_HW", "REVIEW_PANEL_TABLE", "'' = 'Forms!DRAWING_INFO_FORM!Subform_DRAWING_STATUS!Subform_DRAWING_STATUS_CONFIGURATION_HWCI_BL!BL_HWCI_HWCI'") Then If DLookup("GWSHW_BL", "REVIEW_PANEL_TABLE", "'' = 'Forms!DRAWING_INFO_FORM!Subform_DRAWING_STATUS!Subform_DRAWING_STATUS_CONFIGURATION_HWCI_BL!BL_HWCI_HWCI'") Then If DLookup("PCP", "REVIEW_PANEL_TABLE", " = -1") Then MsgBox strMessage, vbInformation, "Action Required" If DLookup("ECN", "ENGINEERING_CHANGE_NOTICE_TABLE", "'ECN' = 'Forms!DRAWING_INFO_FORM!Subform_DRAWING_STATUS!Subform_DRAWING_STATUS_ECN!ECN'") Then I have the following code that I am running when a button is clicked on a Form: If DLookup("ECN_Class_I_Change", "ENGINEERING_CHANGE_NOTICE_TABLE", " = -1") Then ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |