Mykal, you say "I have a form within a database i set up which can be auto populated on the whole by selecting a code from a drop down list which works fine."
How does it do this?
Does the form have an underlying Record Source?
Is it updateable?
Is the TRUST field part of that record source?
I don't like Table based drop downs, I prefer to create them as required on the form.
Does the Table drop down work OK?
Can you posts a database with some dummy data?