Dear forum members:
Kindly help with the following. We have a data-entry form with a button which would allow the user to save the record in a table (multiple copies of the same record similar to what is seen in calendars/events i.e. recurring with the following options 1 to 5: 1) "Every week", or 2) "Every month", 3) 10 times, 4) 20 times, and 5) 30 times.
I created a list box field name "RECURR" which lists the above 5 option but not sure how to proceed from here? what VBA code would be needed to save multiple copies of the current data entry record the number of times based on the users selection.
Any pointers would be helpful. Thank you.
Kindly help with the following. We have a data-entry form with a button which would allow the user to save the record in a table (multiple copies of the same record similar to what is seen in calendars/events i.e. recurring with the following options 1 to 5: 1) "Every week", or 2) "Every month", 3) 10 times, 4) 20 times, and 5) 30 times.
I created a list box field name "RECURR" which lists the above 5 option but not sure how to proceed from here? what VBA code would be needed to save multiple copies of the current data entry record the number of times based on the users selection.
Any pointers would be helpful. Thank you.
