S
sparky
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
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