I have a very simple Continuos Form based on a query displaying 8 columns. One of the column displayed is "Account_Balance". In the form footer, I have a textbox control with control source defined as =sum([Account_Balance]).
When the form is opened, the text box in the footer remains blank. However, If I switch between open windows (using Alt+Tab), the field is found to be updated when I bring the focus back to MS Access window!!!
Has anyone encountered problem like this?
Thanks and regards,