I have one issue that I need some assistance with. My form consists of several cmb fields, a date field, and many option buttons representing days of week. When a date is entered in the "Pay Period Start Date" field, the VBA will create a parameter of three weeks where the true status of the option buttons represent the "Shift" assignment. Blank option buttons are automatically entered as "RDO" (regular days off). There are three sets of butons, each set of which represents a two-week work schedule. Each employee is assigned to a different location every two weeks. Currently, if I enter a shift and select the work days, the employee will be assigned to the same shift for 3 pay periods.
What I'm looking for is an option to select 3 shift assignments for three pay periods.
Example:
First - A0700
Second - A0900
Third - A1400
I know that the combo box for the "Shift" may need to be replaced, so I'm thinking of some type of multiple options list where each choice would be assigned to the First, Second and Third pay period before submitting the schedules.
I'm attaching my sample database.
What I'm looking for is an option to select 3 shift assignments for three pay periods.
Example:
First - A0700
Second - A0900
Third - A1400
I know that the combo box for the "Shift" may need to be replaced, so I'm thinking of some type of multiple options list where each choice would be assigned to the First, Second and Third pay period before submitting the schedules.
I'm attaching my sample database.
