1 00:00:01,419 --> 00:00:03,739 hello i'm ok taxes 2013 tutorials 2 00:00:03,740 --> 00:00:07,319 in this should only talk you through the on load event over form 3 00:00:07,318 --> 00:00:10,740 to gonna play along for the link below to go to dallas exit website 4 00:00:10,740 --> 00:00:14,859 and download access 2013 TV 28 an archtop 5 00:00:14,859 --> 00:00:18,899 as on us to 6 00:00:18,899 --> 00:00:22,629 key okay what I want to talk to you 7 00:00:22,629 --> 00:00:26,509 about download events of forms now these I want to do that 8 00:00:26,510 --> 00:00:30,640 the show tonight for mine and go to reporting 9 00:00:30,640 --> 00:00:36,250 guests and the Los video we set some default values for the 10 00:00:36,250 --> 00:00:40,689 start end dates a and the comic books here 11 00:00:40,689 --> 00:00:45,539 but the problem is we've got on Dez 12 00:00:45,539 --> 00:00:49,780 text boxes before after update prevents a fiery exchange 13 00:00:49,780 --> 00:00:52,840 value to text boxes will 14 00:00:52,840 --> 00:00:56,730 automatically update this report down here 15 00:00:56,729 --> 00:01:00,169 and the reason this is a problem 16 00:01:00,170 --> 00:01:04,349 is actually problem that's good we like to what we don't like is the fact that 17 00:01:04,349 --> 00:01:05,140 when the 18 00:01:05,140 --> 00:01:10,430 the poor opens up lo these have default values 19 00:01:10,430 --> 00:01:14,220 a.m. this report is an actually being so what does he wanna 20 00:01:14,219 --> 00:01:17,609 so what we gonna do 21 00:01:17,609 --> 00:01:21,250 is gonna put the unload event on the form so you too 22 00:01:21,250 --> 00:01:25,299 this opens up filtered with the stakes got it 23 00:01:25,299 --> 00:01:28,610 soap so a cake so close that form 24 00:01:28,609 --> 00:01:32,310 and former interested in is former Port 25 00:01:32,310 --> 00:01:36,600 guests and now a load event of a form 26 00:01:36,599 --> 00:01:40,129 funny enough fires when the form loads 27 00:01:40,129 --> 00:01:45,328 I so it days very stinky might need to do with the form 28 00:01:45,328 --> 00:01:49,559 as it loads this is one example about this penny above examples 29 00:01:49,560 --> 00:01:53,240 2 I'm not gonna go into on this can show you this one puts anyone that's 30 00:01:53,239 --> 00:01:54,719 pertinent to the database 31 00:01:54,719 --> 00:01:58,259 at the moment for gonna do you gonna go to the ven 32 00:01:58,259 --> 00:02:02,019 on the property she is she doesn t matter start there and a 33 00:02:02,019 --> 00:02:05,078 kick in the after update macro 34 00:02:05,078 --> 00:02:09,000 you can hear control a control see so we copy in 35 00:02:09,000 --> 00:02:12,759 event now you go back to it for free she swarmed 36 00:02:12,759 --> 00:02:18,159 and we're gonna go for the onload event the form and we're gonna click 37 00:02:18,159 --> 00:02:21,799 in the three dots micro builder control v 38 00:02:21,800 --> 00:02:24,840 and proof pasted in 39 00:02:24,840 --> 00:02:28,739 Powell my first wonders 40 00:02:28,739 --> 00:02:32,450 of copying and pasting case and now closed at 41 00:02:32,449 --> 00:02:39,259 and open up for main the reports and guests 42 00:02:39,259 --> 00:02:42,709 only to each 43 00:02:42,709 --> 00:02:46,420 a have default values for the dates me also 44 00:02:46,419 --> 00:02:50,169 have this for with down 45 00:02:50,169 --> 00:02:55,738 to the takes you want again said issue times not entirely oldest 46 00:02:55,739 --> 00:03:00,969 trust me it does work actually don't respect adjustment does work okay 47 00:03:00,969 --> 00:03:04,098 thank you for just video anti-vaccine x1 48 00:03:04,098 --> 00:03:05,568 part