Form Textbox - Reference Different Table/Query

I was wondering if it is possible to have a text box control source on a form reference a field from a different table/query than what the form is originally set up to reference in the properties pane without using subforms?

For Example: all the control sources text boxes on my form referece fields from the table "Vehicle_ID" and I want a new text box on my form to have its control source reference a field on the table "CSM_Data". Is this possible without having to embed a subform?

Thank you for any help.