I'm thinking there is no query or textbox involved. The row source for the main tb is a sql statement but can you even use a sql statement for a textbox, especially one that returns several fields? Maybe yes if it's a multi value field (which is something I don't use). Also, don't overlook the fact that columns are usually zero based, so 1,2,3,4 is probably wrong in the first place.
Last edited by Micron; 01-23-2024 at 12:45 PM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.