M
MBoozer
Any ideas why the following code is working for ALL entries? I only want to
display the images (red or green) for EACH individual supplier. Right now, if
only 1 supplier has a corresponding Not Null, then the green dot appears for
all suppliers. Both are subforms.
If IsNull(Me.LocalScanLink) Then
Forms!ChemicalInventory.SetFocus
Forms!ChemicalInventory.EditSuppliers.SetFocus
Forms![ChemicalInventory]![EditSuppliers].Form.imgRedDot.Visible = True
Forms![ChemicalInventory]![EditSuppliers].Form.imgGreenDot.Visible = False
ElseIf Not IsNull(Me.LocalScanLink) Then
Forms![ChemicalInventory]![EditSuppliers].Form.imgGreenDot.Visible = True
Forms![ChemicalInventory]![EditSuppliers].Form.imgRedDot.Visible = False
End If
display the images (red or green) for EACH individual supplier. Right now, if
only 1 supplier has a corresponding Not Null, then the green dot appears for
all suppliers. Both are subforms.
If IsNull(Me.LocalScanLink) Then
Forms!ChemicalInventory.SetFocus
Forms!ChemicalInventory.EditSuppliers.SetFocus
Forms![ChemicalInventory]![EditSuppliers].Form.imgRedDot.Visible = True
Forms![ChemicalInventory]![EditSuppliers].Form.imgGreenDot.Visible = False
ElseIf Not IsNull(Me.LocalScanLink) Then
Forms![ChemicalInventory]![EditSuppliers].Form.imgGreenDot.Visible = True
Forms![ChemicalInventory]![EditSuppliers].Form.imgRedDot.Visible = False
End If