Hello! I have one user form that feeds into another (the originator contact user form) in the first user form a bunch of data is added and then unloaded into the first available column for an "Account".
After that the 2nd user form pops up where they have the option to add an originator contact for that same "Account" in the same column. They can continue to add contacts and it adds the contacts to the bottom of the column until they exit the form.
The issue I'm having is when the user adds another "Account" and gets to the Originator Contact form it starts adding the originators at the row below the one for the 1st originator. I'd like them to the first empty row based on the previous column. I've included a visual below of the issue I'm having. The empty rows are where it should have started filling from (top to bottom) in the 2nd column.
What kind of procedure should I run so this doesn't happen? Any help is greatly appreciated. Thank you!
<tbody>
</tbody>
After that the 2nd user form pops up where they have the option to add an originator contact for that same "Account" in the same column. They can continue to add contacts and it adds the contacts to the bottom of the column until they exit the form.
The issue I'm having is when the user adds another "Account" and gets to the Originator Contact form it starts adding the originators at the row below the one for the 1st originator. I'd like them to the first empty row based on the previous column. I've included a visual below of the issue I'm having. The empty rows are where it should have started filling from (top to bottom) in the 2nd column.
What kind of procedure should I run so this doesn't happen? Any help is greatly appreciated. Thank you!
Returned Items Originator Account | 1 | 1 |
Route | 030 | 030 |
Transit | 1 | 1 |
Originator Contact - Add/Delete | Add | <should here="" starting="" enter=""><I want it to start entering here></should><should here="" starting="" enter=""></should> |
Originator Contact Name | Sue | |
Originator Contact Email | sue@sue.com | |
Originator Contact - Add/Delete | Delete | |
Originator Contact Name | Bill | |
Originator Contact Email | bill@bill.com | |
Originator Contact - Add/Delete | Delete | |
Originator Contact Name | Bob | |
Originator Contact Email | bob@bob.com |
<tbody>
</tbody>