I have a form to assemble assets. It calculates the cost of goods line items and then a total COGS combo box tallies the individual line item amounts.
I want to update the Asset table's COGS and Consumables field with the calculated total COGS amount (when the form is saved).
I have the total COGS combo box and I have a summary page on the form for the asset that pulls the total COGS number over, so I have two locations I can add another command.
Can I combine two expressions? I cannot figure out how to do that without getting error messages.
I want to update the Asset table's COGS and Consumables field with the calculated total COGS amount (when the form is saved).
I have the total COGS combo box and I have a summary page on the form for the asset that pulls the total COGS number over, so I have two locations I can add another command.
Can I combine two expressions? I cannot figure out how to do that without getting error messages.