Patrick Roth looks to keep you from chasing your tail by Avoiding VBA Circular References when using a Dynamics GP Lookup.
Avoiding VBA Circular References when using a Dynamics GP Lookup
Tips & Hidden FeaturesDevelopment & Integration
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.