On the main form I have a combobox where the user can select either "2-Year" or "3-Year from a value list.
If the user has selected "2-Year" from the valuelist combobox I only want to allow for 8 records in the sub-form, no more. If they choose "3-Year" then I want to allow 36 records in the sub-form, no more.
And if they attempt to enter one more record than allowed, in either case, provide a message box telling them that no more records can be added.
Is this possible? The sub-form is a continuous form.