Dear There,
I have a simple database, there is a form subform inside the main form. At a moment, I have fields called USD and other currency in a main form where the USD field is for Total Advance in USD, which then has to be subtracted with the total expenses in subform and results in other field based in the main form called total expense in USD. While user selects USD option from Option group, then other currency field, Rate and total exchange invisible, or the otherway around. Now that I got it works.
The problem is that.
1. when user selects other currency (USD field invisible), fills the figures in the other curreny field, rate and results in the total exchange, but there is nothing in total expense in USD because this field is defined as total expense in USD=[Total advance in USD]-[Total expense] not to other currency field.
I'm thinking of using Dloop to look for any significant inform in USD field in form, if null there then jump to the other currency field and do a calculation but I really don't know how to write the code, where I should start with.
2. After calculatin has been done, I like to click SUBMIT button to send the information of current record to table so that I could show it on the report.
Please help.
Regards,
I have a simple database, there is a form subform inside the main form. At a moment, I have fields called USD and other currency in a main form where the USD field is for Total Advance in USD, which then has to be subtracted with the total expenses in subform and results in other field based in the main form called total expense in USD. While user selects USD option from Option group, then other currency field, Rate and total exchange invisible, or the otherway around. Now that I got it works.
The problem is that.
1. when user selects other currency (USD field invisible), fills the figures in the other curreny field, rate and results in the total exchange, but there is nothing in total expense in USD because this field is defined as total expense in USD=[Total advance in USD]-[Total expense] not to other currency field.
I'm thinking of using Dloop to look for any significant inform in USD field in form, if null there then jump to the other currency field and do a calculation but I really don't know how to write the code, where I should start with.
2. After calculatin has been done, I like to click SUBMIT button to send the information of current record to table so that I could show it on the report.
Please help.
Regards,
