Can't get unbound field to requery

[BJS]

Hi,
I have a form with an unbound control on it. The record source of the control is a DLookup function, which works fine. When updating the table (on which the DLookup Function is based) through different form, my unbound control on the other form that uses the DLookup Function does not refresh.

I have tried requerying the control on the Form's Got Focus, On Activate, and On Current events, with no success. I can get it to requery using OnClick event of the control itself, or the Detail or Header Section of the Form, but I don't want the user to have to click anything for the most recent data to show.

Your help is appreciated! THANKS!

BJS.

 

[KenHigg]

You may have to ref the control directly:

forms!myForm!myTextbox.requery


???
Ken

 

[BJS]

Hi Ken,

My referencing is not the problem. I can't even get a message box going on any of these events for the form.