By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,501 Members | 2,768 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,501 IT Pros & Developers. It's quick & easy.

Field & Field value

P: 41

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..

May 12 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,366
Take a look at the DLookup function.
May 12 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.