I have a table in a form. It is possible that it will contain empty rows. On the next form, I need to gather the data that was entered into the table, but I would like to delete the empty rows automatically.
Here is my table...
If the event field is empty, I would like the entire row to disappear when the information is passed along to the next form.
I have learned how to delete rows when the user enters information into a field. For example, if there was a field that said" Delete Rows?" and "yes" was entered. I have managed to delete rows in this fashion, but I am unsure how to do it between forms. I do not want to rely on user input for the deletion.
I welcome any advice/guidance on the matter.
Thanks.