dlookup and refreshing a form

[Guest]

I have a form which I display via a switchboard menu, in "add" mode. After
entering a date, I have it perform a lookup on a table using the date entered
-1 day, and returns a string. I wish this string to appear after I enter the
date.

I have the control source for TEXT69 =DateAdd("d",-1,[Reading Date]).

I have a textbox for the requested data with a control source =DLookUp("
[METERTable]![todaystation]","METERtable","[METERTable]![Reading
Date]=[Text69]").

When I open the form via form tab, it works, but when I open the form via
the switchboard menu, I never get the requested data.

Any ideas?

Thanks

Rick Miell

 

[Guest]

I have found a way to do this, using a Refresh from data command button.
This will work for what I needed the form to do.

Rick