Hi All,
I have main form and subform in the subform i have quary of the time and date to calculate the Difference of the time between two times and two dates it's appear in the unbounded txtbox named timediff1, so to save the time difference i create txtbox named timediff and i use these code in the setfocus event:
me.timediff=me.timediff1
the problem that i have that when i enter the data starttime "1:00 pm", startdate "20/1/2016", endtime "2:00 pm", endate "21/1/2016" the end date in the next day these error is appear focusing to the code me.timediff=me.timediff1, how can i solve these problem.
i attach some pictures please help
I have main form and subform in the subform i have quary of the time and date to calculate the Difference of the time between two times and two dates it's appear in the unbounded txtbox named timediff1, so to save the time difference i create txtbox named timediff and i use these code in the setfocus event:
me.timediff=me.timediff1
the problem that i have that when i enter the data starttime "1:00 pm", startdate "20/1/2016", endtime "2:00 pm", endate "21/1/2016" the end date in the next day these error is appear focusing to the code me.timediff=me.timediff1, how can i solve these problem.
i attach some pictures please help
