I have a drop down box, when the user selects a value from it, it populates 3 other boxes assuming there is data to populate.
A mutiline box has a formula of - ServiceRequired[Title = Supplier]
When there is no data the user will type their own data into this multi-line textbox. However when they save and re-open the form the data is gone!
My guess was that, when re-opened, the form was re-evalutaing the relationship and reverting the multiline textbox back to what it is in the underlining datasource (empty).
So I thought I would untick the box (properties of text box) that says "refresh value when form is recalculated" but now the box is never populated even when there is underlying data.
Hope I explained that ok. In a nutshell I'd like the user to be able to enter data into this linked box and have it persist regardless of what is (or is not) in the underlying datasource.