I just spent several minutes telling you about the project then seemed to hit the wrong button - black holed it.
Again Sheets 1, 2 and 3 list competitions for which players get points. The Diaries form lets the user edit the comp data. My current design has 3 tables with comp data but POY and Scratch share some competitions. Users have to double edit the dates and could cause some confusion by giving the same comp different names. So I decided to create a single table for POY and Scatch comps. Once the user comits to an update I decided to use the existing code under cmdPostData_Click (see also cmdPostData created from original _Click Sub). So my new code some in Module 4 some in PostDataClick and the problem area in Modul6 is intended to zap and rebuild the POYCompTable and ScratchCompTable and let the more or less unchanged PostData Sub run as before but with added parameters.

Attached Files

POY REV 14.xlsm (266.4 KB, 16 views)