Need Advice On How To Best Update Display From Multi Tables On 1 Form

[drosenkranz]

I have a form with Table "A"'s which is a "client's" record with fields spread about. One of these fields is a "court id" field which relates to another table containing the court's address, city- etc. (This information is displayedalong with the client's info when a user opens the form.

When a user changes the "court id" field on my form, I want the fields from the other table that are displayed on the client's form to update with the new court's info.
I assume it would trigger on the lost focus event of the "court id" field but what's the best way to update the fields when a user changes the court id?
The 2nd mouse gets the cheese.

 

[fluteplr]

On either lost focus or valid of the court id field, requery the court data (I would probably use a parameterized view for this), and then refresh the textboxes or whatever you are using to display the data.