I have a form that I use for control buttons, I created a text box to enter
the date used by an append query to create a table for work schedules. I
added another text box with the following control: DLookUp("[Day_Txt]",
"tbl_Day","Weekday(ServDate)=[Day_Nr]") the result of this box would be used
as the criteria in a query to select the schedules for that particular day.
The problem is that the weekday text box is only updated if I click on the
design dispaly and then return to the form display. Is there a solution that
I can display the weekday based on the date displayed in the "ServDate" text
box?

Thanks
Charles

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200805/1