I am trying to pull data from one form to be used in another.

I have 2 forms that I am using

Form 1      Rates

Form 2      AWB Entry

the Rate form has 3 fields:

      Location

      Airline

      Rate

The AWB Entry has drop down fields for Location and Airline.

AWB Entry also has a Rate field.

I want the rate field to be populated automatically from the Rates form by matching up the Location and Airline fields in the AWB Entry form to the Rates form.

Any help would be greatly appreciated.  I have tried several ways from researching in the help section to no avail

Thomas