For example
Lets say i have a table that I want to populate using a form
The table Name and fields are:
StudentSubjectT - Table
Fields :
StudentID - Autonumber data type
StudentName - Short Text data Type
Subjects - Short Text with a look up display control that allows multiple selection.
I have another table by name SubjectsT and a single field Subjects of short text type.
I have designed a form Student_Subjects_EntryF when it opens it will open on a new record.
I want the form to open with Subjects control box filled in with the last selected subjects for the last student record entered as shown below
I understand that I would need a VBA code on Form Current event to achieve this.
Can some one help me with this VBA code.