Unanswered: Copy data from form to new record in subform
I am setting up a simple database to track employees. In the parent form the details of a new employee are input. Hire details are put in the subform.
When a new employee is input into the parent form I would like the subform to automatically add a record with the employee's ID so that the administrator can simply enter the date, position, etc without having to select the new employee's name from a combo list.
If I set it up as an embedded form, it doesn't recognize the added employee at all. If I set it up as two separate forms, the new employee appears on the list, but they still need to be selected (click on the name).
In the sub form properties, set the master and child fields to point to the respective fields.
These are normally an autonumber field of the master that appears also as a foreign key normal number field of the sub form and its underlying table.
Have you included a field in the second table that is set to store numbers - often indexed but set to accept duplicate values as there could be many records in the sub that relates to the same one id of the master.