Hello All,
I have this form with a combobox and a text field, the text field should lookup a value in a table depending on which selection was made in the combobox. now I have the following formula in the textbox control source:
=DLookUp("[Supervisor]","[tbl-1-0-Areas]","[Area]='" & [Forms]![frm20MainStatus]![cmbArea] & "'")
I have experimented before and this is what happens:
- if I write the values on the combobox using the wizard (I mean, not linked to any table) then the text box finds and shows the required information.
- if I link the combobox to show the values in a table, then the textbox doesn't show anything...
actually, that combobox should filter a query as well, and it happens the same with the query, doesn't work if combobox is pulled from table and works if cambobox values are entered manually...
can anybody tell me why is this happening?