>>>I probably didn't explain myself correctly. Here is a very simplified example. Imagine Order Table. In the order table I will store only the Customer PK (meaningless for the user). When the Order screen is shown the text box should show Customer Name and not PK. As user navigates (goes to next, previous, etc.) records in the Order Table, the Customer Name should appear in this text box. So in the Refresh method of this textbox the code will take the PK value stored in the Order table, find the Customer record in the Customer Table and display the Customer Name. So I can't really use ControlSource of the textbox but have to do it in code.
>>
>>Couldn't you just pull the customer name (include it in your view, datasource, curor) and bind the textbox to that the usual way?
>
>I could; and I thought about it. But I don't want to have this "extra" field carried in each view/cursor where used. So I prefer to have a lighter view and just "bind" it manually. Thank you.

I hate to insist, but if "time is of the essence" then reaccessing your database each time (i.e. on record by record basis) will be much less efficient than to add a field to your view and pull the data once no?