In order to set the Text property of a control, it must have the focus. Would think you would want to set the value instead, but if it worked at all as you have it, you'd simply make the field hold the entire string and not some query result (which I guess you pointed out in your 2nd post). Anyway, at least now you know the reason for the message.
Last edited by Micron; 06-05-2019 at 10:04 PM.
Reason: added comment
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.