I have a form a bit like this

--------------
NAME: Fred Bloggs DOB: 01/10/1969

ADDRESS: xxxxxxxx
xxxxxxxx
xxxxxxxx

-------------

It is made up of two tables, people and address, with a one to many link from people.per_h_addr_id to addr.addr_id

There is a button you can click that displays a form from which you can pick an address, the button then puts the id of the address into people.per_h_addr_id. This works, I know that because when I move off a record and back onto it, the correct address is displayed, however I want it to display the correct address automtically.