Hi,

I did not work on the "Report".
I adde a button for "Modify and New". I only have the "Modify" coded. I do not have the "Add" coded yet.
I thought I' let you see what I have so far.
When you open the file click the "Add?Modify" button.
For test select a "Sku" from the dropdown. the select the Store, date, BGSC, and Account.
You can then click the "View" button. If your selection is not matched it will produce a msg saying you need to verify. If all goes well the data for the selection will appear in the text boxes in the form.
You can make any change in the text box and the click the "Modify" button the will correct the information in you file. There is also a "Exit" button for you to click which will unload the form.

I'm off for now test and let me know.

Attached Files

2016 test_NAT Reship Log-2.xlsm (65.6 KB, 10 views)

This will work perfectly for adding/modifying the data. I am just curious how adding new SKU numbers, Store numbers and Dates will work. This is coming along perfectly and once again thank you for your work.