Hello,
With the forum's help I was able to set up a combobox with a SELECT and Auto Expand turned on to determine the existence of a record being added.
I now realize that I need to take this a step further whereby, if the record exists then populate the field values on the form so additional subform items may be added. If it doesn't, the fields remain empty and can be populated.
The purpose of this form is to add a new Family and records (-> Enrollment -> Student) related to it further down the relationship chain; and to bring up an existing family for which additional records (further down the relationship chain) may be added.
Any guidance would be appreciated.
Regards