I’m sure this came up on the old forum, at least in some form, but I can’t as yet find it here.
There’s a bug in Access whereby the Text property of a ComboBox or TextBox control is inaccessible (even when the control in question currently has the focus) if the control is in the form footer (or header, I think) and the detail part of the form is currently displaying no records. The error raised is 2185, “You can’t reference a property or method for a control unless the control has the focus.”
In a ComboBox in a particular subform, I was hoping to implement some functionality along roughly the same lines as Allen Browne’s Combos with Tens of Thousands of Records. Ideally I would prefer to have the various input controls (including the ComboBox) in the form’s footer rather than in the form’s detail section, but the inability to access the value so far input (via the combo’s .Text property) is a serious problem.
Are there any known workarounds to the issue with the .Text property?
