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.
Last edited by NSTurk725; 09-08-2009 at 02:03 PM.
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,
Docendo discimus.
Please consider:
- Thanking those who helped you. Click the reputation icon
in the contributor's post and add Reputation.
- Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
I hope this helps to answer your questions:
(1) I would like the textbox to write the value to the CSM_Data table.
(2) The relationship between the 2 tables is that they share the same field "Vehicle_Name"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks