1
00:00:01,100 --> 00:00:03,370
I'll look taxes 2013 shoot or ooze

2
00:00:03,370 --> 00:00:06,778
in this video hungry talking to about the Browse to

3
00:00:06,778 --> 00:00:11,740
marker action so if you wanna play along follow the link below the video to

4
00:00:11,740 --> 00:00:14,609
design a sexual website down to Texas 2013

5
00:00:14,609 --> 00:00:18,129
the b12 an anti from that one up

6
00:00:18,129 --> 00:00:22,719
now I hopefully watch the Los video where we created

7
00:00:22,719 --> 00:00:28,419
a navigation form you decide even

8
00:00:28,420 --> 00:00:31,810
centers okay which we took four main

9
00:00:31,809 --> 00:00:35,100
and we've got but I'm here rooms

10
00:00:35,100 --> 00:00:39,120
I'm their own anymore bond buys you click on a used click on different

11
00:00:39,119 --> 00:00:42,909
I'm was entities could have rooms guests bookings et cetera

12
00:00:42,909 --> 00:00:47,519
well I'm interested in today all these buttons here these patterns on the

13
00:00:47,520 --> 00:00:48,670
clothes for main

14
00:00:48,670 --> 00:00:53,170
reside on this form here it's cool for rooms a form rooms

15
00:00:53,170 --> 00:00:57,100
just a simple form for bonds and this bit here

16
00:00:57,100 --> 00:01:00,219
his a subform container

17
00:01:00,219 --> 00:01:05,650
the name if it was cool DS we specified that the

18
00:01:05,650 --> 00:01:10,060
record sources clearance so it nasa like the record source

19
00:01:10,060 --> 00:01:14,549
of the subform the S is form so it is sending DS

20
00:01:14,549 --> 00:01:18,990
I'm so what we want to bid to do with these barns

21
00:01:18,989 --> 00:01:22,969
is we want to be able to open up the same form

22
00:01:22,969 --> 00:01:26,009
we already have I'm but we want to

23
00:01:26,009 --> 00:01:29,450
for example appear to choose to we only want to see active

24
00:01:29,450 --> 00:01:33,359
rooms all we wanna see only inactive rooms and

25
00:01:33,359 --> 00:01:38,009
reason room might be active or inactive issues a example this case the radiation

26
00:01:38,009 --> 00:01:39,200
is a parry said it made

27
00:01:39,200 --> 00:01:44,000
inactive so that you wouldn't I'm take a booking for that room

28
00:01:44,000 --> 00:01:48,040
that's the idea anyway I mean tonight to for so lets up

29
00:01:48,040 --> 00:01:53,310
click on here and change the STU to the labels we want

30
00:01:53,310 --> 00:01:56,478
first one is going to be at New so when you click on this button

31
00:01:56,478 --> 00:01:59,798
I want to bring up the data entry form

32
00:01:59,799 --> 00:02:03,409
paying at moat which is going to be pretty easy

33
00:02:03,409 --> 00:02:08,939
next one is going to be all which means when you click on this bomb

34
00:02:08,939 --> 00:02:12,459
I want to show all rooms as they are

35
00:02:12,459 --> 00:02:16,209
active and inactive response gonna be active

36
00:02:16,209 --> 00:02:22,090
and this bonds gonna be inactive

37
00:02:22,090 --> 00:02:25,259
okay first get the add new one out the way first cuz thats them

38
00:02:25,259 --> 00:02:28,739
really boring okay on click

39
00:02:28,739 --> 00:02:34,700
to macro builder minutes or so if not

40
00:02:34,699 --> 00:02:38,979
open form form name former dictator 3

41
00:02:38,979 --> 00:02:42,899
I'm render mode dialogue promote

42
00:02:42,900 --> 00:02:49,819
at K easy right easy peasy lemon squeezy okay

43
00:02:49,818 --> 00:02:52,979
what's next compared to set up okay

44
00:02:52,979 --> 00:02:56,149
back into lab view I'm

45
00:02:56,150 --> 00:03:00,110
now we net now gets a bit tricky cuz we wanna click on active

46
00:03:00,110 --> 00:03:03,849
and we wanna show essentially the same data she

47
00:03:03,848 --> 00:03:06,929
but where I'm only displays

48
00:03:06,930 --> 00:03:10,939
active rooms you might think that has something to do the filter and I suppose

49
00:03:10,939 --> 00:03:12,818
to some extent it does but the

50
00:03:12,818 --> 00:03:17,199
command you actually need to use is called the Browse to argument an old

51
00:03:17,199 --> 00:03:21,669
show you this in a second to come here I got a macro build-up

52
00:03:21,669 --> 00:03:25,429
just have been I'm browse to

53
00:03:25,430 --> 00:03:28,860
a case and I guess is well yes they were tricky

54
00:03:28,860 --> 00:03:32,530
pickers for even to any that

55
00:03:32,530 --> 00:03:36,408
I say what terror that

56
00:03:36,408 --> 00:03:42,239
I explain something for we can do that this

57
00:03:42,239 --> 00:03:45,739
subform park here is cool DS

58
00:03:45,739 --> 00:03:49,459
and this is houston form rooms which in turn

59
00:03:49,459 --> 00:03:53,810
is housed inform my see gotta remember that part of you can be used

60
00:03:53,810 --> 00:03:58,049
browse to argument okay so now explain that we can take on here

61
00:03:58,049 --> 00:04:02,610
and tap in brown stew okay

62
00:04:02,610 --> 00:04:05,970
so what we browsing to rebels into a form

63
00:04:05,969 --> 00:04:09,479
and the name in the form we want to browse to

64
00:04:09,479 --> 00:04:13,348
his the datasheet its form from sources said the S

65
00:04:13,348 --> 00:04:16,849
which security small you know the actually

66
00:04:16,850 --> 00:04:19,949
is already there so why would we want to browse to form that we have

67
00:04:19,949 --> 00:04:25,750
waste because now but we can't do is you can actually introduced where condition

68
00:04:25,750 --> 00:04:31,540
the specifies the active

69
00:04:31,540 --> 00:04:36,259
equals to achieve this through the activity COO

70
00:04:36,259 --> 00:04:39,840
true alright so

71
00:04:39,839 --> 00:04:43,638
at the moment if you've use the open for logging in before you say this just

72
00:04:43,639 --> 00:04:46,449
looks very much like the open for more human

73
00:04:46,449 --> 00:04:50,199
but his the very guess different you have to

74
00:04:50,199 --> 00:04:53,660
introduced the parts up for control and this one

75
00:04:53,660 --> 00:04:56,830
can be really really annoying sometimes to get right

76
00:04:56,829 --> 00:05:00,430
reason it's annoying is because when you've put the parfait in in order for

77
00:05:00,430 --> 00:05:02,579
this to work you have to actually

78
00:05:02,579 --> 00:05:05,949
I'm close is close forms an open up for Maine and

79
00:05:05,949 --> 00:05:08,960
try from there so group of 26

80
00:05:08,959 --> 00:05:11,969
the soap for control goes form main

81
00:05:11,970 --> 00:05:15,580
which is the name of my a navigation form

82
00:05:15,579 --> 00:05:19,599
dog a nervy haitian

83
00:05:19,600 --> 00:05:22,610
subform

84
00:05:22,610 --> 00:05:26,000
and then you need the arrow that goes across

85
00:05:26,000 --> 00:05:31,430
and then the forms form rooms

86
00:05:31,430 --> 00:05:35,319
talk and its BS which is the name of the

87
00:05:35,319 --> 00:05:40,219
I'm subform container so it's the name on the map navigation for when you just

88
00:05:40,220 --> 00:05:42,650
butt navigation subform

89
00:05:42,649 --> 00:05:45,879
yeah always just navigation subform you have

90
00:05:45,879 --> 00:05:50,110
the no iro goes across us to deny the name the arrow

91
00:05:50,110 --> 00:05:53,470
I'm and then you get the name of the intermediate reform that we made

92
00:05:53,470 --> 00:05:58,160
in the last to tour which is formed rooms and Dawn NDS which is the name of

93
00:05:58,160 --> 00:05:59,780
the container

94
00:05:59,779 --> 00:06:03,478
if you say that close to like I said before if I try and actually do this

95
00:06:03,478 --> 00:06:04,579
here

96
00:06:04,579 --> 00:06:07,829
I get this valid par for June reason is

97
00:06:07,829 --> 00:06:11,969
invalidated because is looking for Maine but was ok snow here so be safe than

98
00:06:11,970 --> 00:06:13,789
clothes that

99
00:06:13,788 --> 00:06:18,060
a member of the four main and now we try

100
00:06:18,060 --> 00:06:21,439
and we we prayed they work

101
00:06:21,439 --> 00:06:25,228
moves first time for everything okay as you can see

102
00:06:25,228 --> 00:06:28,918
it's made who has made all these inactivity sign in Ashburn apartments

103
00:06:28,918 --> 00:06:30,209
the listed as

104
00:06:30,209 --> 00:06:35,459
active I'm so we will close that

105
00:06:35,459 --> 00:06:38,668
I mean you can if you want you can right clicking got a layout view into it from

106
00:06:38,668 --> 00:06:40,318
whoever

107
00:06:40,319 --> 00:06:45,379
summarizes the bad o2 its work on a form you working on

108
00:06:45,379 --> 00:06:48,500
okay super active so what we do click on that

109
00:06:48,500 --> 00:06:52,269
control I E control C close to

110
00:06:52,269 --> 00:06:56,430
gotta inactive backer builder control v

111
00:06:56,430 --> 00:07:00,478
so we just copy and pasted the macro just changed

112
00:07:00,478 --> 00:07:05,379
folks

113
00:07:05,379 --> 00:07:09,389
and go to who and click on again

114
00:07:09,389 --> 00:07:13,478
control v and just get her to the WHERE condition for stock

115
00:07:13,478 --> 00:07:16,629
say even close safe thankful

116
00:07:16,629 --> 00:07:20,250
loans another soap for main

117
00:07:20,250 --> 00:07:25,228
ice and now we've got some options we can at the moment this makes the school

118
00:07:25,228 --> 00:07:28,560
we can make active we can look at inactive

119
00:07:28,560 --> 00:07:31,819
rooms so we can see rooms that need maintenance

120
00:07:31,819 --> 00:07:36,000
and we can go back to home and we can click had no

121
00:07:36,000 --> 00:07:40,060
another room Arctic so that is the

122
00:07:40,060 --> 00:07:44,530
well the browse to argument that you need for navigation forms

123
00:07:44,529 --> 00:07:48,989
I'm this is that one loss the cadet because it is

124
00:07:48,990 --> 00:07:53,769
wat camby little bit nightmarish

125
00:07:53,769 --> 00:07:57,008
if this bit the stuff everything else is easiest justice beheaded stuff just

126
00:07:57,009 --> 00:07:58,240
remember its

127
00:07:58,240 --> 00:08:02,389
the name of the navigation form than dot navigation subform

128
00:08:02,389 --> 00:08:06,240
the right arrow in the name of the intermediate reform

129
00:08:06,240 --> 00:08:10,668
then talk I and then the name with the subform container

130
00:08:10,668 --> 00:08:14,680
that's why when I make these into major she formed always called a subform

131
00:08:14,680 --> 00:08:19,310
contained in TS

132
00:08:19,310 --> 00:08:24,680
because this really easy to remember that that name in a sub for retailer

133
00:08:24,680 --> 00:08:28,360
okay so thank you watchin and CNNX video