Text-box instead of a list box or combo-box

[ion97]

For a specific field which looks up values from a table, I want to use a text box, not a combo box or a list box.

When I do so I get the first column (bound column) of the table, which is something I don't want. Can I use the text-box and have the second column displayed?

Note: I don't care if the text-box will be updatable or not.

 

[Jack Cowley]

What code are you using to 'lookup' the data?

 

[ion97]

No lookup code, just the Row source property is set to:
SELECT [tblAUTH].[ID], [tblAUTH].[NAME] FROM tblAUTH;
All I want is to have the name appearing on the text box, not the ID number

 

[Jack Cowley]

=DLookup("[Name]","tblAUTH")

You will need to add the Where clause to the DLookup function to return a specific record. Look in Help for examples. Also, Name is a reserved word in Access and you should change your field name to something else...

 

[Rich]

Since the value is already in your combo then put the control souce of your textbox to=[ComboName].[Column](1)