I am getting variable not defined, with this Form_Subform_Example1.txtbox2 = 3. I am trying point to a textbox on a subform from the main form. It highlights 3. What are some possible solutions or examples?
Yes that works perfectly, my form is much more complex then this one. The image of it is the blueprint of my form. Everything works perfectly except for the sum field not updating, after the value changes the in the total field. It does update if you place your cursor in the total field, and you...
I attached an image of what it looks, except my mines is done through vba for fd1 and fd2.
me.total = me.fd1 + me.fd2
The sum field will not recognize there was a change in total field. If I did place my cursor in the total field and type 38, and press enter. Then it will capture the change...
I am just looking for a sample suggestion to try out.
Description of Subform (continuous form)
The quantity field for each row used to be user enter. Now it is automated. I have a textbox where you enter any number, and a combo box to pick a number. The total field shows calculated value...
The weird thing on my other access the code is exactly the same except for a different form, and it works perfectly. I have a calculated textbox on the mainform that shows the sum of the subform continuous form. I have tried various methods, and textbox is just not updating at all.
I have a text box where you enter a value, and combo box where you select a value. Then I have another text box that show the calculated value for that row. Then below the calculated value, there is another text box that shows the sum of the calculated value per row. Say for example row 1 is 67...