I am trying to create a form that will allow a user to enter sales forcasting information for each month of a given year. I have created a form that contains the following fields: Client Name, Year and Representative. I have then created a subform that is linked by the client name and year. I need to be able to have each month of the year (Jan-Dec) appear automatically on the subform so that the user can enter information for that month. Each month of data should be each own record. If I create a label for the month, I don't see how that data will transfer back to the table. I have created a drop down box; however, would rather have 12 lines appear-one for each month where the month is automatically populated. I have attached a copy of the form and subform so far.
I would greatly appreciate any help!!!!