Hello everyone!


I have a form that contains 2 subforms, this form is a date form that comes after a project form, so this is the date by project record, now the subforms 1 of them comes with a table displaying the staff of my company the other subform I want it to register the staff that worked in that project and on that date.
My question is...
I want that when the user doubleclicks on a staff name field (in the staff subform) it will take that Staff id and open a new record in the other subform (I call it date_staff)
I have everything wotking at the moment except for the doubleclicking in the staff name and putting that staff id in the staff id field in the other subform... (as a new record)

Your help will be hightly appreciated and let me know if you have any questions...

Saludos / Regards,
Rodrigo Leija