Dlookup Value in a Combo Box 1

[pdldavis]

Hi, I'm having trouble getting the syntax correct for looking up a value in a combo box. There is one bound column and two other fields. I am interested in displaying one of the other columns in a text box on the same form in a different area.

I think the text box control source should be something like <=dlookup(&quot;[desc]&quot;,&quot;[combobox]&quot> where the field [desc] is one of the unbound fields contained in the combo box and [combobox] is the control that has the field. Or is dlookup the correct function to use?

Any help would be appreciated. Thanks.

 

[BoxHead]

DLookUp pulls a value directly from a table or saved query.

If I understand your goal here, you should be able to referenmce the other columns of the combobox on the combobox's BeforeUpdate event with the following.

TextBoxName = ComboBoxName.Column(2)

Be aware that the first column in a combobox is numbered zero. Also, the column in the combobox that you reference doesn't have to be visible. You can set the column's width property to 0&quot; and still reference it for display elsewhere.


HTH
John

Use what you have,
Learn what you can,
Create what you need.

 

[pdldavis]

Thanks for the help. It solved my problem. I did not know that the first column was '0' either. Solves a few mysteries too.
Thanks, Dan