Display lookup value in text box

[Blitznb]

I have a search form that has a text box that needs to be bound to [SIC1] but show a lookup value. Anyone know how to do this with out making it a combo box?

I tried setting the control source to DLookup, but it appears as though the text box doesnt know what value to bind to the box and gives a #type or #name error.

 

[missinglinq]

As written, your post would appear to make little sense. Why would you need to have a Textbox on a Search Form bound to a Field, then populate it using DLookUp?

I think a better explanation of what you're trying to do is needed, as well as a copy of your attempted DLookup code.

Linq ;0)>

 

[Blitznb]

The text box displays an id value when the results are shown. I am trying to get it to show a lookup value.


Please see attached screen shot.

Issue is SIC 1 field is a combo box in the Entry Data Section.
In the results when bound to SIC1 it just displays the ID, where I would like for it to display the Name/Code.

I feel as though I have tried all variations of DLookup with no success.