I have a form giving details of an academic group, with a datasheet subform showing the pupils in the group.
The subform holds the pupil id number and his/her full name.
Currently the pupil ID is entered and the full name appears for confirmation.
I would like to be able to enter new pupils by their name if their ID is not available, using a combobox that filters the names as the use types in the first few characters. When a name is selected, the Id should appear, i.e. the converse of the usual input process.
Not sure how I set about this.
The subform holds the pupil id number and his/her full name.
Currently the pupil ID is entered and the full name appears for confirmation.
I would like to be able to enter new pupils by their name if their ID is not available, using a combobox that filters the names as the use types in the first few characters. When a name is selected, the Id should appear, i.e. the converse of the usual input process.
Not sure how I set about this.