Text field updating problem

[Scottie]

Group,

I am using the following control source for a text box on my form

=DLookUp("[LastOfRoomChangeDate]","res_source_step 2","[RID] =
[Forms]![res_residents]![RID]")

The lookup was working great, not anymore...now it only updates when
clicking the textbox...or waiting until it adds updates it almost a 2 minutes
later or by making the textbox the first tab stop......

I am using Access 2007....any ideas to what might be causing it to run this
way...or preventing my field from being updated

 

[Allen Browne]

One solution would be to Recalc the form, e.g.:
Me.Recalc

Another is to leave the text box unbound, and assign a DLookup() result to
it in a suitable event.

You will need to decide what "a suitable event" is. Perhaps the Current
event of the form, or the AfterUpdate of the controls it depends on.