Empty Query/Table results

[aimless54]

First off, I hope to help others in the future on this site...not just have issues!

I created a database where I needed to add fields to get the total in another field- field 1 + field 2 = Totals Field (not exact names of fields)

I did this in the form which was the only way to get it to work, but the numbers in the totals field does not carry over to the table or the query.
Please help!

The fields that are suppose to ad work ok, but the totals field just says 0

 

[boblarson]

Per normalization rules you really shouldn't be storing the value unless you have items that make up those values that change over time. That being said, put

Me.YourTextBoxTotalNameHere = Me!Field1 + Me!Field2

in the BeforeUpdate event of the form.

 

[aimless54]

Per normalization rules you really shouldn't be storing the value unless you have items that make up those values that change over time. That being said, put

Me.YourTextBoxTotalNameHere = Me!Field1 + Me!Field2

in the BeforeUpdate event of the form.

What would me be? The form name? Engineering.Priority=engineering!field1 +engineering!field2

?

 

[boblarson]

Me is a shortcut reference to the current form that the code and objects reside on. So, if your code, and the objects that you are referring to are on the same form, then you can use
Me.YourTextBoxNameHere
instead of
Forms!YourFormNameHere.YourTextBoxNameHere

 

[aimless54]

Oh, thanks, will give it a try

 

[aimless54]

Still can't get it to work. I am still working on my access skills- so I am not very good!