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?
 
GRayLConnect With a Mentor Commented:
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
 
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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
 
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:
Thanks, glad to help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.