Good day,
I need some help with a form.
I have a table with one field -Exchange rate. I have a form to input the exchange rate when the rate changes.
I have a form to input data into my Expenditure table, and a combo box to read and input the exchange rate into the Expenditure Table from the Exchange rate table.
In both tables the filed is set to
Data type = NUMBER
Field size = DOUBLE
Format = FIXED
Decimal places = 5
On both forms the combobox properties are:
Format = FIXED
Decimal places = 5
When I click on the combo box on the expenditure form, I see only one decimal, and only one decimal is captured in the table.
Would someone please tell me what I am missing. I dont know how to write codes.
Thanks
I need some help with a form.
I have a table with one field -Exchange rate. I have a form to input the exchange rate when the rate changes.
I have a form to input data into my Expenditure table, and a combo box to read and input the exchange rate into the Expenditure Table from the Exchange rate table.
In both tables the filed is set to
Data type = NUMBER
Field size = DOUBLE
Format = FIXED
Decimal places = 5
On both forms the combobox properties are:
Format = FIXED
Decimal places = 5
When I click on the combo box on the expenditure form, I see only one decimal, and only one decimal is captured in the table.
Would someone please tell me what I am missing. I dont know how to write codes.
Thanks