I'll look taxes 2013 shoot or ooze
in this video hungry talking to about the Browse to
marker action so if you wanna play along follow the link below the video to
design a sexual website down to Texas 2013
the b12 an anti from that one up
now I hopefully watch the Los video where we created
a navigation form you decide even
centers okay which we took four main
and we've got but I'm here rooms
I'm their own anymore bond buys you click on a used click on different
I'm was entities could have rooms guests bookings et cetera
well I'm interested in today all these buttons here these patterns on the
clothes for main
reside on this form here it's cool for rooms a form rooms
just a simple form for bonds and this bit here
his a subform container
the name if it was cool DS we specified that the
record sources clearance so it nasa like the record source
of the subform the S is form so it is sending DS
I'm so what we want to bid to do with these barns
is we want to be able to open up the same form
we already have I'm but we want to
for example appear to choose to we only want to see active
rooms all we wanna see only inactive rooms and
reason room might be active or inactive issues a example this case the radiation
is a parry said it made
inactive so that you wouldn't I'm take a booking for that room
that's the idea anyway I mean tonight to for so lets up
click on here and change the STU to the labels we want
first one is going to be at New so when you click on this button
I want to bring up the data entry form
paying at moat which is going to be pretty easy
next one is going to be all which means when you click on this bomb
I want to show all rooms as they are
active and inactive response gonna be active
and this bonds gonna be inactive
okay first get the add new one out the way first cuz thats them
really boring okay on click
to macro builder minutes or so if not
open form form name former dictator 3
I'm render mode dialogue promote
at K easy right easy peasy lemon squeezy okay
what's next compared to set up okay
back into lab view I'm
now we net now gets a bit tricky cuz we wanna click on active
and we wanna show essentially the same data she
but where I'm only displays
active rooms you might think that has something to do the filter and I suppose
to some extent it does but the
command you actually need to use is called the Browse to argument an old
show you this in a second to come here I got a macro build-up
just have been I'm browse to
a case and I guess is well yes they were tricky
pickers for even to any that
I say what terror that
I explain something for we can do that this
subform park here is cool DS
and this is houston form rooms which in turn
is housed inform my see gotta remember that part of you can be used
browse to argument okay so now explain that we can take on here
and tap in brown stew okay
so what we browsing to rebels into a form
and the name in the form we want to browse to
his the datasheet its form from sources said the S
which security small you know the actually
is already there so why would we want to browse to form that we have
waste because now but we can't do is you can actually introduced where condition
the specifies the active
equals to achieve this through the activity COO
true alright so
at the moment if you've use the open for logging in before you say this just
looks very much like the open for more human
but his the very guess different you have to
introduced the parts up for control and this one
can be really really annoying sometimes to get right
reason it's annoying is because when you've put the parfait in in order for
this to work you have to actually
I'm close is close forms an open up for Maine and
try from there so group of 26
the soap for control goes form main
which is the name of my a navigation form
dog a nervy haitian
subform
and then you need the arrow that goes across
and then the forms form rooms
talk and its BS which is the name of the
I'm subform container so it's the name on the map navigation for when you just
butt navigation subform
yeah always just navigation subform you have
the no iro goes across us to deny the name the arrow
I'm and then you get the name of the intermediate reform that we made
in the last to tour which is formed rooms and Dawn NDS which is the name of
the container
if you say that close to like I said before if I try and actually do this
here
I get this valid par for June reason is
invalidated because is looking for Maine but was ok snow here so be safe than
clothes that
a member of the four main and now we try
and we we prayed they work
moves first time for everything okay as you can see
it's made who has made all these inactivity sign in Ashburn apartments
the listed as
active I'm so we will close that
I mean you can if you want you can right clicking got a layout view into it from
whoever
summarizes the bad o2 its work on a form you working on
okay super active so what we do click on that
control I E control C close to
gotta inactive backer builder control v
so we just copy and pasted the macro just changed
folks
and go to who and click on again
control v and just get her to the WHERE condition for stock
say even close safe thankful
loans another soap for main
ice and now we've got some options we can at the moment this makes the school
we can make active we can look at inactive
rooms so we can see rooms that need maintenance
and we can go back to home and we can click had no
another room Arctic so that is the
well the browse to argument that you need for navigation forms
I'm this is that one loss the cadet because it is
wat camby little bit nightmarish
if this bit the stuff everything else is easiest justice beheaded stuff just
remember its
the name of the navigation form than dot navigation subform
the right arrow in the name of the intermediate reform
then talk I and then the name with the subform container
that's why when I make these into major she formed always called a subform
contained in TS
because this really easy to remember that that name in a sub for retailer
okay so thank you watchin and CNNX video