I have a form with two subforms. The first subform is linked to the master form with the SKU fields and works perfectly. I want the second subform to link ManufPartNo which is a field on the first subform. I created a textbox on the main form named MPn and set it's control source as follows:
When I try to link the second subform, the field MPn is not on the Master Fields list.
This has always worked for me when I was using Access 2000, now I'm using Access 2010. What am I doing wrong?