Dlookup Combobox

[zeroeu]

Hey I have a form with cascading comboboxes, and I'm using a textbox to display the value, when the combo values dissapear.



However the textbox displays the numbers that refer to the first column of the bound field and not the text value. Is there a dlookup solution to this?

The basic architecture is.

a table Recipe Components

With each item and categories and subcategories of each item listed.

I want the textbox on the form to display the text values like the table does.

The categories and subcategories are each held on 2 other distinict tables.

Thanks

[Rod]

Someone should have answered this days ago!

There can be (and often is) more than one column for a combo box. Without specifying a column, the value of a combo box is its bound value. Check the property window for each of your combo boxes under the Format tab. Look for Column Count. I guarantee the number will be greater than 1. Look also at Column Widths. Each measurement corresponds to a column and I guarantee at least one of the measurements will be zero, effectively hiding the corresponding column when displayed on the form.

You need to decide which column contains the text value you want. Instead of:

txtMyText = cboMyCombo1 & " " & cboMyCombo2

you need something like:

txtMyText = cboMyCombo1.Column(1) & " " & cboMyCombo2.Column(1)

Note that columns are numbered relative to zero so Column(1) is the second column.