I have a form with a subform displaying data from a related table. Unfortunately there is not room across for all the fields on the related table. So I put an extra control on the form with the Control Source set to [TasksSubform].[Form]![Priority]. OK, so when browsing the data on the subform the data in the extra control changes accordingly, great. The problem is that the extra control is readonly, when I try to edit its value it say "control cannot be edited it's bound to the expression." How can I allow the extra control to be editable? Or is there another way to do this?
Thanks.