Referring to another table for a text box

[hawkins]

I fee like this is a really simple question but am having troubles with it. I have two tables one called static and one called JurisdictionList. In the static table I have a column header named Jurisdiction which is populated with numbers that are referred to the JurisdictionList table by the column named ID in that table. The ID field has a designated location. I was wondering how I can use a text box to refer to that designated location. I can get a text box to populate with the number in Jurisdiction but I would like to use that number to relate to the location. Any suggestions are appreciated!

[pbaldy]

Is this what you're trying to do?

http://www.baldyweb.com/Autofill.htm

[hawkins]

Similar but not exactly what I need I dont think, the report is a page report for each feeder name, and the name is found by [Reports]![MainRep]![FdrName]. I would just like a text box I believe because I do not want to choose from a list I want the value that is stored in Jurisdiction field to be used to relate to the full location name in the location field and display that full location from the JurisdictionList table in the text box.Does that make sense?

[pbaldy]

Yeah, I missed that is was on a report. Typically your report would be based on a query that joined the two tables on the common field. That enables you to include the other field from JurisdictionList. Does that sound appropriate? Or am I still goofed up?

[hawkins]

oh ok that makes sense! I was going to try to get around a query because I already have 9 for the report but I'll just make another. Thank you for your help!

[pbaldy]

No problem, post back if you get stuck. That's definitely the normal method. An alternative would be DLookup(), but it would be much less efficient than letting the query do the work.