1
00:00:01,469 --> 00:00:04,660
a local taxes 2013 22 ruthless video

2
00:00:04,660 --> 00:00:08,359
I'm gonna be showing you how to open up a form

3
00:00:08,359 --> 00:00:11,820
to a specific record site

4
00:00:11,820 --> 00:00:16,910
who should apply long I'm go to the download section website

5
00:00:16,910 --> 00:00:20,699
and download X 2013

6
00:00:20,699 --> 00:00:23,800
BB 10 make for a link below the video

7
00:00:23,800 --> 00:00:27,039
and then open up in this

8
00:00:27,039 --> 00:00:30,220
the lease move I've ever done re-write

9
00:00:30,219 --> 00:00:35,219
min now worry a in the last video we created for rooms

10
00:00:35,219 --> 00:00:41,149
a well we create for room sorted ascending which was it eighty she

11
00:00:41,149 --> 00:00:44,439
we are a little bit condition for my aim we

12
00:00:44,439 --> 00:00:48,890
colette the background in the alternate row property you're interested in doing

13
00:00:48,890 --> 00:00:53,439
is using this field he and when we click on

14
00:00:53,439 --> 00:00:57,878
an item it's a number seven what we want is for this form to open up

15
00:00:57,878 --> 00:01:02,608
but for to go to reminding them seven so bright

16
00:01:02,609 --> 00:01:06,260
and actually is so if we

17
00:01:06,260 --> 00:01:10,170
to come here and on the property she

18
00:01:10,170 --> 00:01:15,259
go to vent if you don't see property she just press before and go to click

19
00:01:15,259 --> 00:01:18,659
HomeClick and macro do what we can do to serve a macro

20
00:01:18,659 --> 00:01:22,830
we can say open form

21
00:01:22,829 --> 00:01:26,530
name the form its former

22
00:01:26,530 --> 00:01:30,469
data entry you want it to be dialogue

23
00:01:30,469 --> 00:01:34,908
and reciprocal space for added I'm

24
00:01:34,909 --> 00:01:38,290
and his way we specify which record we open to

25
00:01:38,290 --> 00:01:42,049
sweeper in the wake and issue for equal whose I'm

26
00:01:42,049 --> 00:01:45,930
to open a close quotation marks open/close square brackets

27
00:01:45,930 --> 00:01:50,110
and room ID he cools

28
00:01:50,109 --> 00:01:53,420
ampersand room I D

29
00:01:53,420 --> 00:01:58,560
save that hang clothes that

30
00:01:58,560 --> 00:02:01,930
and

31
00:02:01,930 --> 00:02:07,310
I'm school sorry changed to form you already in Africa conference of a number

32
00:02:07,310 --> 00:02:08,098
eleven

33
00:02:08,098 --> 00:02:11,169
we get rooms open up to number 11

34
00:02:11,169 --> 00:02:14,878
if we click on the mind i guess im effing

35
00:02:14,878 --> 00:02:19,929
I want to click on new upper

36
00:02:19,930 --> 00:02:24,560
we get a syntax error occurs with no new is in a values just passing and no value

37
00:02:24,560 --> 00:02:28,569
so cause the park so

38
00:02:28,568 --> 00:02:31,589
we can do with that we go back to the Mac for Euro

39
00:02:31,590 --> 00:02:34,680
and we're using this condition who say

40
00:02:34,680 --> 00:02:37,780
if I not

41
00:02:37,780 --> 00:02:43,930
is no through mighty

42
00:02:43,930 --> 00:02:46,989
so we're going to ask the question as to whether the

43
00:02:46,989 --> 00:02:52,610
number we've clicked on here with will kick in if you want to ask western

44
00:02:52,610 --> 00:02:53,580
rivers know or not

45
00:02:53,580 --> 00:02:58,530
no means empty or no value no ni part here this AM till no value

46
00:02:58,530 --> 00:03:02,348
no values down here we hit new sorry saying if it

47
00:03:02,348 --> 00:03:09,348
isn't like that we want to open the form

48
00:03:09,430 --> 00:03:13,750
up to specific record at else

49
00:03:13,750 --> 00:03:19,620
now if it he's a no value are still open up this form Forms Data Entry

50
00:03:19,620 --> 00:03:25,439
will open up dialogue 2010 opening up to add record

51
00:03:25,439 --> 00:03:29,930
no save that for now to the same thing again

52
00:03:29,930 --> 00:03:36,489
i click on for example number six and hopes of Numb six we fuck

53
00:03:36,489 --> 00:03:41,009
Kong nu doesn't cause me problems opens up the same form

54
00:03:41,009 --> 00:03:44,598
we hope is up to a new record which is kinda nay

55
00:03:44,598 --> 00:03:48,869
is quite nice way of doing things datasheets okay and we're just 81

56
00:03:48,870 --> 00:03:52,049
lost look at that where condition sometimes this

57
00:03:52,049 --> 00:03:55,500
for his people off a little bit I'm

58
00:03:55,500 --> 00:03:59,449
case you say the room ID I clicked on was number six the actual condition with

59
00:03:59,449 --> 00:04:05,250
to miss a very mighty 46 and you passing the school district very processed

60
00:04:05,250 --> 00:04:10,068
be in quotation marks prime primer use a Nazi open up the

61
00:04:10,068 --> 00:04:14,359
form I am remember the who's at the star that for those people off sometimes

62
00:04:14,360 --> 00:04:18,519
and and that's it really very much more to say about that

63
00:04:18,519 --> 00:04:21,720
if you're but I will say other remark conflict too much

64
00:04:21,720 --> 00:04:26,650
if you're if the food you I am using the WHERE condition for

65
00:04:26,649 --> 00:04:29,888
for example this is a number for all to numb

66
00:04:29,889 --> 00:04:32,978
something like type this is a text field

67
00:04:32,978 --> 00:04:39,478
I'm you need to use single quotation marks I so shut the setbacks us a little

68
00:04:39,478 --> 00:04:40,659
bit too complicated

69
00:04:40,660 --> 00:04:45,110
addicted to video on that and access 2010 shoot or so

70
00:04:45,110 --> 00:04:48,009
don't get too much into that this is the way condition this is the most simple

71
00:04:48,009 --> 00:04:49,949
way conditional use to open up

72
00:04:49,949 --> 00:04:54,189
performs the specific records let's keep it simple a great thank you for watching

73
00:04:54,189 --> 00:04:55,779
and I should see you in the next video