Text Box options?

[mrmims]

Hello,

I have a two text boxes.



1st (SystemSWLkg) is bound to SystemSWL in tbl_Axes. It is the Safe Working Load of a piece of equipment in kilograms.
2nd (SystemSWLlbs) is an unbound box doing some maths to just display the SWL in pounds.

Half of my crew thinks in kg and the other half thinks in lbs. Currently, we are only able enter data into SystemSWL in kg because the SystemSWLlbs is only for maths.

How do I make it so data can be entered into both boxes, displayed with the proper conversions, and stored in my table as kilograms if entered as pounds?

Thank you for your help!

[pbaldy]

You can have code in the after update event of both, each updating the other appropriately. Only the kilogram box would be bound.

[Missinglinq]

You can have code in the after update event of both, each updating the other appropriately. Only the kilogram box would be bound.

And so that the Unbound 'pounds' Textbox will be correct, when moving from Record-to-Record, you'll need to do the conversion math (from the 'kilos' Textbox AfterUpdate event) for it in the Form_Current event, as well.

Also note that this approach will only work if this is a Single View Form.

Linq ;0)>