Lookup formula for a text box on a form

[pkarnowski]

Hello,

Here is what I need help with.

I have 2 tables with data in them, they both have a common Item #. I have a form that brings up data as requested by entering an item number but the table that the form gets the data from does not have a part name in it. I would like to add a text box to my form header that looks at the item number in the form text box and brings back the part name from my other table. If it were excel I would use vlookup but access does not seem to have that option or I don't know where to find it. I tried linking it in the query that my form pulls from but it comes up blank

 

[pkarnowski]

I got it!! Thanks