Hopefully this is an easy one...... Have a form... With two subforms. Info is entered into first subform... Second subform shows a recap of info entered. Kind of a running total of an "Average" based on info input on the first subform.
OK... Problem is... The second subform updates... requeries the info on close. I want it to update the info every time a new line or record is entered into the first subform. I have tried a couple of ".requiry"s on the first subform... but no luck. I'm not that hot with VBA yet.... And can't seem to get anything else to work. Solution????
Thanks
OK... Problem is... The second subform updates... requeries the info on close. I want it to update the info every time a new line or record is entered into the first subform. I have tried a couple of ".requiry"s on the first subform... but no luck. I'm not that hot with VBA yet.... And can't seem to get anything else to work. Solution????
Thanks