if drawing_type is a text field why are you trying to fill it in with a number?, which is basically what NZ does?
Code:
m_intDrawingType = Nz(DLookup("drawing_type", "[FILEA MAPPS]", "Signal_ID = '" & [Forms]![form1]![Text4] & "'"))
Try this first:
Code:
m_intDrawingType = dlookup("Drawing_Type", "[FILEA MAPPS]", "Signal_ID = '" & forms!form1!text4 & "'")
debug.print m_intdrawingtype
NOTE: IN YOUR MOST RECENT CODE YOU STILL HAVE " MARKS AROUND FORMS!FORM1!TEXT4 WHICH IS NOT WHAT YOU WANT IF YOU ARE TRYING TO PULL A VALUE FROM A FORM
if this gives you the correct 'drawing_type' response then you should be golden, though I do not know why you are mixing data types
I would define m_intDrawingType as a string then check it as a string value in your check
Code:
if m_intDrawingType = '1' Then ...