I want to put a vba code that will lookup values from a different table when I update a specific field in a form. The values should be available every time I start the form or navagate from one record to another. It should also be dynamic so that it refreshes everytime i move to a diffrent record