Hi axe again. This time I have the theory that access hates me. how is it possible that I use a macro in a database but I cant use is it in the same exact conditions in another database? This time I'm trying to store in a table the result of the sum of to text fields inside a form using a macro. I successfully did it on another db as I said y even used the same names for the fields and the syntax is the same!! this is what I'm doing:
The two fields of the form are called [Subtotal] and [Tax] they both contain this expressions:
Subtotal -- =[sfrmOrder].[Form]![txtSubtotal] "this one is getting the value from a subform"
Tax -- =[Subtotal]*0.16 "this one get the tax amount"
I'm using a macro after the update of the Subtotal field I'm using the action SetValue with this arguments:
[Forms]![Purchase Order].[Texto63], =[Forms]![Purchase Order].[Subtotal]+[Forms]![Purchase Order].[TAX]
But all I get is a big "TYPE MISSMATCH" error 2950
This mistake raised a question about the use of dots and bangs also may that be the syntax mistake? or does access really hates me? I hope you can help guys! thanks