I have a form that I would like to take the number in one field (Current Inventory) and subtract it from the number in another field (Desired Inventory). I created a query from the original table and put the equation in. This works in the query. I then put the 2 field boxes into the form and a generic text box for the equation named "Number to Order". In the property sheet of the text box, I entered the equation (=[desired inventory] - [current inventory]). This results in #Name? in the text box.
I also tried entering (=[Number to Order]![Desired Inventory]-[Number to Order]![Current Inventory]). [Number to Order] is the name of the query. This also resulted in the #Name? notation. Sometimes it has resulted in the notation #Type!
Any suggestions would be appreciated.
I also tried entering (=[Number to Order]![Desired Inventory]-[Number to Order]![Current Inventory]). [Number to Order] is the name of the query. This also resulted in the #Name? notation. Sometimes it has resulted in the notation #Type!
Any suggestions would be appreciated.