automating lookup

[NotMyJob]

The screen capture below is of a tab control that runs a query on tbl_request on the field status and returns all 'new' requests. That part is simple. What I would like to do is come up with a way for the two boxes above the table to automatically populate as the user scrolls down the table. Those are contact info for the home team and that information is held in tbl_team. Is there a way for access to look up those 2 values and change them as the user scrolls down the main table?

[pbaldy]

Sure, you can use the current event of the form. Simplest might be DLookup(), more efficient might be a recordset.