I need to have more than 4 linked fields between my Main form and the subform, is this possible?
I need this because the linked fields get automatically populated with the field data in the master form for each linked field when entering new records. Having looked at various methods to do this, linking the fields seems to be the easiest way to achieve this, but I need to link 5 fields.
Thanks
Thanks for the reply. Not a direct answer to my problem, but I found a solution by using a macro to read the value in the fifth field on the master form, then changing the default text value of the correpsonding column in the subform and issung a save record and refresh. The subform now shows all five fields ready populated for new records.
Being able to link 5 fields would have avoided the macro.
I will mark this thread as solved. Thanks.