For each record criteria & formula fields

For each record criteria & formula fields

I have two forms (A & B). Form A has the following fields:

Lot

Description

formula field combining the two fields Lot_Desc.

Decision box

Form B has a lookup to form A using the Lot_Desc field.  

In a script on Form A I am using a For Each Record in Form B with criteria to match on Lot_Desc. No records match. However if I change the lookup to use just the Lot field the criteria works correctly. Are formula fields not allowed in the criteria?

for each x in Batch  [Lot == input.Lot] works

for each x in Batch  [Lot_Desc == input.Lot_Desc]  does not work


Herb Wexler