Actually the link is VERY good :-> (One of mine).
But may I suggest one last run at this from a slightly different angle.
As you are already reconciled to choosing the relevant form before opening it, how about a single form with a parameter. In the Form_Open() procedure (before the record source is processed), determine from the parameter which record source (and if necessary which control source) is required. That way, a single, slightly more clever form is used.
Benefits of this approach include the feeling that you've been clever; There are fewer forms to maintain; Adding an extra one simply involves adding some logic to the code rather than producing a whole new form (albeit very similar to pre-existing ones).
But may I suggest one last run at this from a slightly different angle.
As you are already reconciled to choosing the relevant form before opening it, how about a single form with a parameter. In the Form_Open() procedure (before the record source is processed), determine from the parameter which record source (and if necessary which control source) is required. That way, a single, slightly more clever form is used.
Benefits of this approach include the feeling that you've been clever; There are fewer forms to maintain; Adding an extra one simply involves adding some logic to the code rather than producing a whole new form (albeit very similar to pre-existing ones).
Comment