a local taxes 2013 22 ruthless video
I'm gonna be showing you how to open up a form
to a specific record site
who should apply long I'm go to the download section website
and download X 2013
BB 10 make for a link below the video
and then open up in this
the lease move I've ever done re-write
min now worry a in the last video we created for rooms
a well we create for room sorted ascending which was it eighty she
we are a little bit condition for my aim we
colette the background in the alternate row property you're interested in doing
is using this field he and when we click on
an item it's a number seven what we want is for this form to open up
but for to go to reminding them seven so bright
and actually is so if we
to come here and on the property she
go to vent if you don't see property she just press before and go to click
HomeClick and macro do what we can do to serve a macro
we can say open form
name the form its former
data entry you want it to be dialogue
and reciprocal space for added I'm
and his way we specify which record we open to
sweeper in the wake and issue for equal whose I'm
to open a close quotation marks open/close square brackets
and room ID he cools
ampersand room I D
save that hang clothes that
and
I'm school sorry changed to form you already in Africa conference of a number
eleven
we get rooms open up to number 11
if we click on the mind i guess im effing
I want to click on new upper
we get a syntax error occurs with no new is in a values just passing and no value
so cause the park so
we can do with that we go back to the Mac for Euro
and we're using this condition who say
if I not
is no through mighty
so we're going to ask the question as to whether the
number we've clicked on here with will kick in if you want to ask western
rivers know or not
no means empty or no value no ni part here this AM till no value
no values down here we hit new sorry saying if it
isn't like that we want to open the form
up to specific record at else
now if it he's a no value are still open up this form Forms Data Entry
will open up dialogue 2010 opening up to add record
no save that for now to the same thing again
i click on for example number six and hopes of Numb six we fuck
Kong nu doesn't cause me problems opens up the same form
we hope is up to a new record which is kinda nay
is quite nice way of doing things datasheets okay and we're just 81
lost look at that where condition sometimes this
for his people off a little bit I'm
case you say the room ID I clicked on was number six the actual condition with
to miss a very mighty 46 and you passing the school district very processed
be in quotation marks prime primer use a Nazi open up the
form I am remember the who's at the star that for those people off sometimes
and and that's it really very much more to say about that
if you're but I will say other remark conflict too much
if you're if the food you I am using the WHERE condition for
for example this is a number for all to numb
something like type this is a text field
I'm you need to use single quotation marks I so shut the setbacks us a little
bit too complicated
addicted to video on that and access 2010 shoot or so
don't get too much into that this is the way condition this is the most simple
way conditional use to open up
performs the specific records let's keep it simple a great thank you for watching
and I should see you in the next video