Changing a Label

[graviz]

First off thank you everyone who has helped me on my journey into learning Access. You guys are awesome! What I'm trying to do now is have a label change based upon a value in a text box. I basically have a query I created that has two columns. (Location Numbers & Location Names). On my form there is a textbox named "txtfacnum". This textbox is the criteria for the location number in my query "[Forms]![InputForm]![txtfacnum]". What I would like to do is automatically display the location name in a label based upon what the user enters in that textbox (for the location number). I hope this makes sense.

 

[Kryst51]

Hi Graviz,

Read up on this thread, I think there are several ways to accomplish this.