convert currency combobox

I need some help making my form more efficient. Right now, I have a textbox "Currency Rate" and a combobox "Currency Type". The user chooses a bunch of items that he wants to buy and all the prices show up by default in dollar. Then let's say he wants to convert to Euro. He would enter the rate in tbCurrencyRate and then choose "Euro" in the combobox. My code then checks which currency he is converting from and multiplies or divides all the prices by the value in the textbox acccordingly. This works very well, but can be very confusing for the user, having to remember to first put the rate in and then choose the Currency Type. It just doesn't seem so smooth. Any ideas to make this smoother?
cers4686Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rockiroadsCommented:
Not sure whats wrong with that. Perhaps you can have the afterupdate event on the textbox as well so if they change either value in combo or rate then updates on the screen occurs.
0
GRayLCommented:
Why not maintain a table tblUS2Currency containing 2 fields CurrencyName, ExRate?   Base a 2 column combo box on the table:

SELECT CurrencyName, ExRate FROM tblUS2Currency ORDER BY CurrencyName;

Now you only need 1 combo and a regular update of the table.  There are lots of sites with currency conversion tables you could import into your table.
0
cers4686Author Commented:
GRayL - that wouldn't work bec' let's say - in one record I converted the dollars to euro at a rate of 3.14 then i comeback next week and want to convert back to theoriginal dollaramount - but now the rate is 3.16...
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

GRayLCommented:
I said you have to maintain the table - probably daily.  You are going to trust users to enter the 'correct' conversion rate??
0
GRayLCommented:
In re-reading this, are are looking to exchange back at the same rate in the previous transaction?
0
GRayLCommented:
Perhaps you should make sure the question clearly states what you need.
0
jmoss111Commented:
Hello cers4686,

We update the exchange rate daily and set the exchange rate and rate date in the invoice record when created. Its the only way to get a true valuation

Regards,

Jim
0
GRayLCommented:
If the 'natural' way is to select the currency first, you can park the cursor in the currency combo box when the form opens - and change the tab order so that the rate box is selected after the currency is selected.  You could even disable the rate box until a currency type is selected.  Is this what you are getting at?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GRayLCommented:
Thanks, glad to help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.