Dlookup problem

[Terava]

Hi again. For some reason I can't get dlookup working.. Can some one help? http://sdrv.ms/122smYp there is the file.. And in toimittamattomat_kysely_L is Dlookup test field.. I try to get some customer info related to this box.. Addresses are in yhteystiedot. Can someone check what i do wrong..? -Jani

[Parsonshere]

Rename the combo box txtAsiakas so it's NOT the same as the field name.
Use the combo box name, not the Label Caption in Dlookup statement.
Tunnus is a long Integer and does not require delimiter " ' "
=THaku("[Sukunimi]","Yhteystiedot","[Tunnus]=" & [Forms]![toimittamattomat_kysely_L]![txtAsiakas_tiedot])
However, in my English Version, I did not get this to actually work - Don't know if it will.

[Terava]

thanx.
Fixed combo box name.. I should be careful..
Now it dosn't give error but still returns empty..
New improved version in link.. ITS THE FIELD IN form: TILAUS-> MUOKKAUS55
(next to that)

Also tested in toimittamattomat_kysely_v3 in field muokkaus36 box
There is used english version code..

Now gives an error.. help.. I got it working in other place, so there is now still some error.. Does some one find it?
-Jani

Rename the combo box txtAsiakas so it's NOT the same as the field name.
Use the combo box name, not the Label Caption in Dlookup statement.
Tunnus is a long Integer and does not require delimiter " ' "
=THaku("[Sukunimi]","Yhteystiedot","[Tunnus]=" & [Forms]![toimittamattomat_kysely_L]![txtAsiakas_tiedot])
However, in my English Version, I did not get this to actually work - Don't know if it will.

[June7]

I downloaded the file but not seeing the edits recommended by Parsonshere. Not finding anything with the exact name toimittamattomat_kysely_L.

Not sure I would use DLookup.

Options:

1. multi-column combobox to hold the address info

2. form RecordSource that joins the two tables, then bind textboxes to the fields from yhteystiedot, set properties Locked Yes and TabStop No

[Parsonshere]

=DLookUp("[Sukunimi]","Yhteystiedot","[Tunnus]=" & [Asiakas_tiedot])
I didn't really review the merits of your methods, but just to get the Dlookup working, this statement does work.
You have the sql referencing itself, by using the combobox name where I have placed Asiakas_tiedot in the statement.
Again, watch the control names to make sure they are not the same as the field name.
When you rename the control, the statement will automatically change(Unless you change the default option),
so after renaming a control, check the statement or clauses that referenced them again.

[Terava]

Hi. These solved my problem.. Thank you all for helping me!!!
-Jani