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.

Hi NSTurk725,

Without answering your question, I have to ask:

- What do you intend to do with the data you place in the text box? Do you want the form to write the text box data to the "CSM_Data" table, or is there a place for it in the "Vehicle_ID" table (or is it just for display)?

- Is there a relation/join between the tables?

- If yes, would you expect the form to write data to both tables? (Subforms generally make this easier.)

- If no, then how does the form overcome the ambiguity and know what to write to the table?

Cheers,