Change a value in a text box

[gsanders32]

Access 2000, I have a question about reports and text boxes. I made a form that stores a County_ID from a list instead of the county named in the table. I did this because in my report I need to show a County Name, Zone, and Region. Here is the list of tables: List_County, Well_Schedule, Form: Well_Schedule_1, Report: Observation_Well

List_County

County_ID County_Name Zone Region
1 Lubbock 1 3
2 Lynn 1 2
and so on

Question in the report how do I make a text box show the County_Name not the County_ID?

I was able to do this if I had the Well_Schedule_1 form open. But I want to do this without the form being open.

Thank you

 

[dhookom]

Add the List_County table to your report's record source, join the appropriate fields, add County_Name to the output fields, and bind a text box to your field.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[gsanders32]

dhookom

Is there a different way to do this; maybe code or something?
I have 15 more lists that I would need to add, and that is ok but when I added more then 5 tables to the report record source the text box control source goes blank. I also got a mismatch error.

 

[dhookom]

I don't understand what you mean by "text box control source goes blank". I expect you might have used the mis-feature of lookup fields in your table designs. This causes great confusion.

IMHO, you are much better off making sure the fields you want to see in your report, are in your report's record source.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[gsanders32]

dhookom

I had a table linked wrong and all the information vanished. I fixed the link and everything is now working great.

Thank you for helping me