filled text boxes based on combobox choice

[optidisk]

Hi
I have been searching this forum for 3 hours for a solution, some come close others are pure gobble de gook to me.
I have on a form 1 combobox where a name is chosen, from that choice I would like the address, suburb, state etc automatically placed intheir relevant fields.
I have tried =DLookUp("[PropertyAddress]","tblProperty","[Property]") in the address textbox which will only bring up the first recod's address from the table, if I change the name in the combobox the address doesn't change.
What am I doing wrong, I have designing databases in Access for a total of 7 days now and have been going fairly well with some tips and code snippets from this forum but this has got me stumped.

Cheers
optidisk

 

[Oldsoftboss]

Download the 2 samples I posted here... http://www.access-programmers.co.uk/forums/showthread.php?t=95772

The second one is pulled apart to show how it works.


Dave

.

 

[optidisk]

xlent, many thanks - just the ticket