Unanswered: Storing copy of a mainform field value in subform table
I have a mainform with a field called DeptID, which is a listbox. How can I store the value selected for DeptID in mainform, under the table used by subform. There is a field called PDeptID in subform table which needs to hold this value.
I have tried referencing the mainform field in subform, by using [Parent]![DeptID] under control source, but it doesn't seem to work.