Hi, I have looking for an answer for this but cannot find.
I have a textbox on a form and I want the control source of the text box to be a field which is in a different table. So the form has a record source of a table called tblstatus but I want the control source for the textbox to be a field on another table called tblContractor.
How do I do this?