This is going to look like I'm re-inventing an Outlook calendar. Anyway, I'm trying to figure out how to create recurring events in a task table via a command button on a form.
On the form are various data entries that I want to copy over to a new record in the table.
But also on the form is:
A checkbox (chkbxRecurring, table field name = Recurring)
A combbox selection which the users selects from if the checkbox was checked (cboFrequency, table field name = cboFrequency)
A textbox which gets populated after a selection has been made in cboFrequency (txtTimesPerDay, yable field name = TimesPerDay)
A textbox (txtFrequencyEndDate, table field name = FrequencyEndDate = Date field)
If the user clicks the commandbutton I want new records to be entered, unless they have already been entered that duplicates various other fields on the form but only if:
chkbxRecurring has been marked true
And enter a recurring date based on the field, cboFrequency.
Here is a snapshot of the records in cboFrequency:
And stop creating new records on the txtFrequencyEndDate
If anyone has a clue as to how to code this one it'd sure be appreciated.