Change textbox from showing PK to showing field value

[Stephenson]

Hello all,

I have a textbox, tboStreetName in sfrmVendorCon that I'm using in a continuous form. The value of this control displays the primary key (StreetID) from my table, tblStreetName. I would like this control to display the text stored in the field StreetName in tblStreetName rather than the primary key.
I realize I can change the textbox to a combobox and build a simple query, but I don't want to display the control as a text box.

I'm banging my head against the wall trying to get a DlookUp to work for the Expression Builder, but am having no luck. I've tried several variations, the following is my latest...

=DLookUp("StreetName","tblStreetName","StreetID= " & [Forms]![sfrmVendorCon]![tboStreetNumber])

I can't seem to find the correct way to write this.
Please let me know what I'm doing wrong on this DlookUp.

I'm also curious if a DlookUp may be a poor choice. Will this cause the DB to slow down much running on a continuous form that holds roughly 1K records? If so I would love to hear about better alternatives.

Thanks for looking,

John

[RuralGuy]

Yes, a DLookup() will slow down the form. Can you join the two tables in a query?

[Stephenson]

RuralGuy,

I hadn't even thought of joining them in a query. I don't have much experience with queries, but am going to see if I can figure it out.

Thank you for the help.

[Stephenson]

Thank you RuralGuy.

I was able to make this work using a query. I had not done this before. It was a great learning experience for me.

Have a great day.

[RuralGuy]

Excellent! Thanks for posting back with your success.