But there is one more little thing. How do I make that enable/disable formatting update based on each record in the form? In other words, I want each record to have one text box enabled and containing data and the other box disabled and empty.
This is an inventory cycle count database where we enter our inventory discrepancies. When inventory is inaccurate, it can either be off by a full pallet amount or a partial pallet amount. So there are two text boxes:
Text box 1 = Qty of full pallets
Text box 2 = Qty of partial pallets
The rule is you can either have a full pallet discrepancy OR a partial pallet discrepancy but never both.
I want to prevent the data entry clerk from ever entering a qty in Text box 1 AND a qty in Text box 2 on the form. My ideal scenario would be that for each record, when something is entered into Text box 1, Text box 2 would become disabled, and likewise for Text box 2.
The solution you provided was limited in that the property for the Disabled text box would carry over to the next record regardless of whether something had been entered into the field or not. I want the property to reflect whatever values are in Text box 1 or 2 based on each record.