Here is a little more detail:
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.
For example:
Record #1
TB1 = 5
TB2 = Disabled
Record #2
TB1 = Disabled
TB2 = 5
Does this help?
Thanks for your patience and time.