Dave Gulliksen
New member
- Local time
- Today, 04:30
- Joined
- Mar 29, 2006
- Messages
- 3
All,
I have a form in Access 2000 (Windows XP) with several subforms. Each subform has a total in the footer that works fine. In the main form, I pull the totals from every subform into unbound fields with a calculation in each field and also calculate a grand total in another unbound field. That works fine.
I also have a type of "filter". Each record in my main table has a field with "Y" or "N". My form query excludes records marked "N". To change the "filter", I run an update query based on some calculations that set each record to "Y" or "N" in that field, and I only see the "Y" records. Works great!
My problem is this: Sometimes the update query marks EVERY record "N". That's OK, there are no records that match what I asked to see, so showing no records in the form is fine. BUT when I rerun the update query based on another criteria and I show some records again, my fields getting the data from the subform always calculate as error, until I close the form and open it again. Interestingly, the field that calculates the grand total still works.
I've tried recalc, requery, showallrecords, refresh, repaint - nothing reactivates the calculated fields. They apparently can't find the fields in the subforms.
Any thoughts why this would be happening and how I could fix it? I apologize for the complexity of the question.
Dave Gulliksen
Stratford, CT USA
I have a form in Access 2000 (Windows XP) with several subforms. Each subform has a total in the footer that works fine. In the main form, I pull the totals from every subform into unbound fields with a calculation in each field and also calculate a grand total in another unbound field. That works fine.
I also have a type of "filter". Each record in my main table has a field with "Y" or "N". My form query excludes records marked "N". To change the "filter", I run an update query based on some calculations that set each record to "Y" or "N" in that field, and I only see the "Y" records. Works great!
My problem is this: Sometimes the update query marks EVERY record "N". That's OK, there are no records that match what I asked to see, so showing no records in the form is fine. BUT when I rerun the update query based on another criteria and I show some records again, my fields getting the data from the subform always calculate as error, until I close the form and open it again. Interestingly, the field that calculates the grand total still works.
I've tried recalc, requery, showallrecords, refresh, repaint - nothing reactivates the calculated fields. They apparently can't find the fields in the subforms.
Any thoughts why this would be happening and how I could fix it? I apologize for the complexity of the question.
Dave Gulliksen
Stratford, CT USA
