I have a form where the user selects a category, and two additional fields are populated based on the selection. These fields are text fields, but their contents are numeric. I built it this way while following a tutorial. I have tried making these numeric fields in both the user form and the form from which the data comes, but the results did not populate the lookup field, so I went back to text.   I am trying to use the lookup fields in a few calculations with no success.   The first formula adds the two lookup fields together but does not work The second calculated field multiplies a user input by a lookup field; this does not work either.  I have other calculated fields on the form that work properly; they do not use lookup fields.    Is there something that I am overlooking when using lookup fields?