Updating calculated field on focus

[davesmith202]

Whenever the focus switches to my switchboard, I want the calculated fields on it to be updated with the up-to-date values. They have dcounts based on queries.

What event do I use and what code to update the values?

Thanks,

Dave

 

[rainman89]

there is a gotfocus property and in there you would do a me.requery

 

[davesmith202]

Thank you.