How to show a textbox of related data on a form?

[diddydustin]

I have two tables, Dispatch and D:Route_Info. I have a tab control with two pages, 'driver info' and 'route info'. Basically, when the user selects a dispatch entry (a driver making a stop, leaving, or returning) on the main form, the tab control needs to show info on that route from D:Route_Info. D:Route_Info and Dispatch are related by Route.

My problem lies in showing the related data in a textbox. I'm just not sure how to approach this problem. Is it a simple solution, or do I need to code this somehow?

Thank you!
Dustin

 

[dpimental]

One suggestion is to relate all the associated tables together.

Then build a query of the related tables.

Then use the query as the RecordSource of the Form with
The Tab Control on it.

Then create the textbox, and set the control source appropriatedly.

Or am I missing your point entirely