The below code throws an error on this line: If [RetLocationID] Like "S*" Then.
I thought it was because there are times when no values will be present.
In the query I'm checking the field [RetLocationID] for Null and replacing with "A", but it still throws an error.
So clearly I'm doing something wrong.
What am I doing wrong?
Code:
RetLocationID: Nz([POHeader]![RetLocationID],"A")
Code:
If [RetLocationID] Like "S*" Then
Me!BarCodeMsg.Visible = True
Me!BarCode.Visible = True
Me!BarCodeReceiptID.Visible = True
Me!StoreAssociate.Visible = True
Me!StoreAssocInst.Visible = True
Else
Me!BarCodeMsg.Visible = False
Me!BarCode.Visible = False
Me!BarCodeReceiptID.Visible = False
Me!StoreAssociate.Visible = False
Me!StoreAssocInst.Visible = False
End If
thanks!