Basic Q: how to show one field

[Terava]

Hi. I have form and it has data from many places. Example customers orders etc. Form returns from customers database only a customer key number to form. Question. How to I get to this form to show different values from customer database. I don't want to see just a selected customers number but customers name, address etc. in seperate info box.help please.. did someone understand? =)

[pbaldy]

Like this?

BaldyWeb - Autofill

[June7]

Options:

1. a multi-column combobox with a row source that displays all customer info

2. form has RecordSource that joins customers table with orders table, set the JOIN type as "Include all records from Orders and only those from Customers that match" then bind textboxes to the fields from Customers and set them Locked Yes, TabStop No

3. DLookup expression in textboxes

[Terava]

http://sdrv.ms/ZSxa1Y

Can someone have a look this.. 6h later still don't get Dlookup working.. In "toimittamattomat_kysely_l -> Ruutu_sukunimi"
I want it look in Yhteystiedot -> Sukunimi (aftername) and right number/Sukunimi from asiakas_nro (from toimittamattomat_kysely_l)

I have looked so many helps but it always give me #name..

Can some one make correct my mistake? I want to see more info than a customer number..

-Jani

[Terava]

Hi.
Thanks for info!
Can someone look my file... many hours later and I still don't get Dlookup working..

Here's the file:
http://sdrv.ms/122smYp


There is 2 "dlookup test" fields where I have tried..In toimittamattomat_kysely_L
(Yhteystiedot = addressbook)

I cant figure what's wrong..
-Jani

[pbaldy]

Looks like the problem is being addressed here:

https://www.accessforums.net/access/...lem-34493.html