Any help with this would be greatly appreciated, as I am no programmer...
I have a form on which the first field, cboStartDate, always a Monday, is picked from a combo box. Works correctly.
The form has a multi-select combo box, cboAirDays filled with days of the week, with two fields; the (hidden) bound column contains values 1-7, the second is what the user makes his choices from Mon-Sun.
The AfterUpdate event needs to do two things. First is to count the number of days selected, put that in txtAiringCount field, which used in a calculation * txtRate. That works correctly.
I'd like the user to be able to see the actual dates in another field txtAirDates, just for information to verify. So for instance, if the cboStartDate is 6/29/20 and the user selects Tue and Thu (2 and 4), the txtAirDates field should display "6/30, 7/2"; Mon, Wed, Fri selection would display "6/29, 7/1, 7/3" in the txtAirDates field, etc...
Let me know if you need any other information to help me with this bit of VBA.
Thanks in advance!