Hey, I have a main form(frmInfo) with a subform(frmHistory), and then I have links to other forms for each of the twelve months(frmJanuary-frmDecember). Basically, I store a running total of the values of text boxes in each of the twelve forms and then display the value in a text box that is based on a query in "frmHistory". I want to display the updated amount after I enter the new value and close the frmJan. I know I am supposed to set the code to run after the close event of the update form, basically I need to requery the value of a text box displaying values off a query after the form closes.
Im using this code:
Forms!Info!History!Expr1.requery
but keep getting this error message:
"Database cannot find field "History" in expression"
Any ideas? It seems fairly simple,
thanks,
Will
Im using this code:
Forms!Info!History!Expr1.requery
but keep getting this error message:
"Database cannot find field "History" in expression"
Any ideas? It seems fairly simple,
thanks,
Will