Forcing field to recalculate

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I have a calculated field on a form which calculates based on values form
two sub forms. How can I force the field to recalculate when data in any of
the sub forms is changed? I have tried myfield.recalc and myfield.refresh
but neither is supported vba.

Thanks

Regards
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Test form for changes on close 6
Access Sub form opens before the main form in MS Access 0
recalculate a score for old records in a new field 3
manually update field - want to create calc. but probl prev. table 3
Recalculating when an Excel sheet gets the focus from outside Excel 10
Forcing to recalculate 7
Query doesn't recalculate 2
if field changes show msg box to recaluclate 1

Back
Top