I have a txt box in the form footer of a SubForm that SUMS a field of the subform. I have an unbound textbox on the MainForm whos control source is that Form Footer Sum Field. On Current for the Form I set a Bound txtbox = to the unbound text box. All works fine until the number of records in the subform grows at which point the Bound txt box displays its default value "0". If i step through the on current event the value in the Bound txt box becomes correct. The other way I can get the Bound txt box to display the proper value is to manually increase the height of the Subform. I have the Details section of the subform set to Can Grow....I'm guessing I am missing something simple....anyone have an idea what that might be?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
On current for Form not working properly unless manually resize Subfom
- Thread starter adams1416
- Start date
