Copy and paste type action

[alcifer]

Good evening,
I need to copy a field value from a child subform to its parent form. The field in question is [Employee Number]. Subform is called [Caller Details] and form [call record]. Thanks, I'm stuck, I know this should not be hard...

 

[wizcow]

Can you just high light the text and right mouse 'copy'
Select other form and right mouse 'paste'

 

[alcifer]

Yes, I suppose I could ask users to do this, however, not a practical solution. When something is enterred in one field, I wish the field to be auto filled.

 

[Pat Hartman]

I think you need to rethink your forms and/or table structure. The subform shows the many-side data of a one-to-many relationship. If you can enter EmployeeNumber in a subform, you CANNOT store it in the one-side table since the next row of the subform could contain a different EmployeeNumber. Perhaps you should have EmployeeNumber in the One-side table and display it on the main form so that EVERY record of the subform relates to the same EmployeeNumber.

 

[alcifer]

Thank you thank you thank you. Something so basic, works like a charm... Al