Hello, basiclly this is what i got -

seprate databases in Access which have for example "FromPounds" database
which has a new colum for each country and what the excange rate would be, and in the vb program i have 2 drop down boxes one " FromCurrency" and "ToCurrency" a "convert" command button and "txtAmount" enter box and "txtResult" result box, i would like the "FromCurrency" cbo box to be able to find out what currency it is trading from, and the "ToCurrency" cbo box to find the conversion rate in the database, then the "toCurrency" cbo box will need to be multiply by what the amount has been entered into the "amount box"

tbh i do not want to have to write out 100 if statement due to needing to use 10 different countrys. if any one could help this would be welcome