I have a very simple table that has 8 fields and 10 rows (Basic asset table). I currently save this as a CSV file and update as needed. i am trying to create an application that will allow me to use the search box to find a record (using any field) and then display 8 input boxes that show the values for the selected record in the search box. once this record is showing, the user should be able to make changes and hit a "submit" button (macro) to update the record in the CSV file. I can handle the majority of this (I think). I am stuck on how to set up the input boxes to both show the existing record and then allow the user to change it. I assume it would be an "On Selection" trigger to set Variable based on the selected record.
I would rather try to use two objects for each field - one textbox with a getfieldselections() which shows the current value and below them a empty inputbox to edit a new value and with executing the macro the variables from the inputboxes will be emptied again.
Otherwise the variables must contain the getfieldselections() and be re-created with the macro-execution. The Showing and hiding of all objects would I do per visibility-conditions over a variable which will be triggered from the (right) selection.
