2 currencies, one store one

[Traden]

Hi,
i have a very simple question. I do have a form, in that form i do have Textboxes for values. I need them because some incoming deliverys have another currency.I want the form to work that way:

Case 1: no entry in first textbox (witch repesents Thai Baht), only entry in 2 Box (for Euro Value), store the euro Value in Datasheet

Case 2: Entry in Thai Bat box, converts automaticly with an exchange rate form a different table to Euro and stores the Euro Value.

Perfekt would be that when something is in the Thai Baht Value box, it is not possible to write in the Euro Box something else then the calculated stuff.

I have tried to do that with a query, but i am not good at VBA, anyone a pattern for me pls?

thanks

traden

 

[Traden]

thanks for the views, i already solved...

but another question is, how could i set the default value of a textbox, with the result of a query? What is the VB Command for that.
I am now using Comboboxes for it, and they show me the right results, but it would look nicer if i could use Textboxes

thanks