I have a main form that contains a tab control with 3 tabs. On each tab is a subform and there is a "comments" text field on each subform.
On two of the subforms I can edit the contents of this text field ok. On one I can't. I've checked all the usual stuff about making sure AllowDeletions is set to Yes on each subform and that the text field is Enabled and not Locked. I've now been at this for 4 hours and nothing I've tried has worked (including adding a second subform with a different recordsource) but I still can't edit the text field. It's as if there's some kind of disconnect between the text field and the linked table (it's a split db). The recordsource is just selected from the recordsource dropdown in the data tab of the subform's properties (not created dynamically although I've tried that too with same result). Thanks in advance for any suggestions.
On two of the subforms I can edit the contents of this text field ok. On one I can't. I've checked all the usual stuff about making sure AllowDeletions is set to Yes on each subform and that the text field is Enabled and not Locked. I've now been at this for 4 hours and nothing I've tried has worked (including adding a second subform with a different recordsource) but I still can't edit the text field. It's as if there's some kind of disconnect between the text field and the linked table (it's a split db). The recordsource is just selected from the recordsource dropdown in the data tab of the subform's properties (not created dynamically although I've tried that too with same result). Thanks in advance for any suggestions.