Immediate Update of Unbound Field

[FormerJarHead]

Hi All,


I'm sure this is a fairly simple but I can't figure it out.

I have a bound form with an unbound calculated field that works as it should when I leave the form and then come back to it.
How do I get it to populate the field after the calculation is completed and before I close the form.

Thank you for any suggestions...

[ssanfu]

Have you tried Me.Refresh?? (See Help)

[FormerJarHead]

I have. I've also tried Me.Requery. I've done that to both the Form and to the control itself...neither did any good.

[ssanfu]

I should have read your post closer. Do you mean you have a calculated FIELD defined in a table??


You shouldn't save calculated values in a table for several reasons....
See this page by Allen Browne:
http://allenbrowne.com/casu-14.html

Note the 2nd to the last paragraph.....

[FormerJarHead]

No. What I have isa form with an underlying query. I havean unbound calculated field on the form called WaitTime that uses the OnCurrent event ofthe form, Me.WaitTime = DateDiff("d", ReferralDate,Rep). This calculates perfectly but not until Ileave the form.

I've tried putting in the Me.Refresh and Me. Requery inthe forms After Update Event with no luck. It's not a huge issue but deputies will be inputting data into thisform. If they do not see the fieldpopulate before moving onto the next record, they will assume it is notworking.

[ssanfu]

The "OnCurrent" fires when the record changes.

Have you tried "Me.Recalc" to force a reclaculation?

[FormerJarHead]

I have. I should have shared this info earlier on, this is in Access 2010, but things should be pretty close with all. Like I said earlier, it works great in the OnCurrent, I need to figure out a way that it will populate once I tab to the next field...

[Missinglinq]

If you already have this Form running off of a Query, then do the calculation in the Query, with a Calculated Field! Go into the Query Grid for the underlying Query and place this in a new Field:

WaitTime: DateDiff("d", [ReferralDate],[Rep])

Now go into your Form and use the new WaitTime Field as the Control Source for the Textbox on the Form.

Linq ;0)>

[FormerJarHead]

The form is running off of a query but, not the unbound field. Problem is solved. What I was trying to accomplish was to have this unbound field update before leaving the form so there would be no confusion as to whether or not the field populated. By inserting this VB in "On Exit" in the field before the unbound field, when the user tabbed to the next field, my unbound field would populate. Thanks again to all that gave me some ideas and made me think more than I care too...Stay Safe..