Field & Field value

[solargovind]

Hi,

I am using Ms Access'2000.

I have one Table called Rate_Table which contains all the rate for my consignments.,viz...Rate for the particular weight and for the particular country
Note : Weight,USA,UK,UAE, etc.,are the fileds...

In one Combo box, i hve called "Weight" field's DATA as list of weight. Its for selecting the weight.

In another combo box, I hve called the all FIELDS in combo box by using Field list as Row source type to select countries.

Now, In a Textbox, i need to display the Rate for the particular Weight and for the particular Country by selecting the above said two combo boxes...

How could i do this...?

Any suggestion would be greatly appreciated.

Thanks in advance..

ngr.

[Rabbit]

Take a look at the DLookup function.