>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.
try a
GO RECNO()
before you refresh the form. This slaps some sense into the relationship, and reminds it to refresh itself.
FWIW, this is one of the many reasons I don't use table relationships...
Erik Moore
Clientelligence