I have a form that is bound to a query. When I first open up the form, the
form displays fields from the first record.
On the same form, I have a drop down (NameDropDown) and a command button
(SearchBatter). What I want to happen is when the user selects an item from

I would like to find books that are advanced with ACCESS formulas. Do
you have any suggestions. I want to learn all the advanced functions/
formulas such as =Switch, =IIF(And, and all the complicated formulas.

Hello can any tell me where I can get a free grant deed fill in form?

I am trying to set an expiration date in my form.  What it does is if
the classroom is Bumble Bears, then add 1 year to the field [Date].
If the classroom is Kool Kidz, then it needs to default to 9/1/? (?
being the year of the next 9/1).  This is what I have so far.  Can

I have 5 different Classrooms.  Kool Kidz is the only what that has a
criteria.  All classes, I need one year added to [Date], Kool Kidz
criteria is If [Date] is >=9/2/07 then expiration is 9/1/08, if [Date]
is<9/2/07 then add one year to [Date]. I know it must be close, but it

I'm creating a membership database for an organisation. A problem I've
encountered is the young lady that will be using the completed database is
occasionally using control/z to undo an input error too frequently and
deletes the record that she is inputting. As the membership ...

I am working in a form.  I have a field called Visiting Date and a
field called DOB and a field called Classroom.  I am trying to come
up
with a formula in the Visiting date that will show if a Child's

Good afternoon,
I have been trying to figure out for the last three days now, how I can show
the previous months fuel readings on the next months record.  I don't know if
I've been looking at it too long or what but I've hit a brick wall in trying

I am having trouble getting rid of my form's property page when I switch from
design view to form view. Is there some way of making it only appear in
design view? Thanks.

I have two forms. One is Parent Information and One is Child
Information. When I am editing an existing record in a Parent
Information, I would like a button to take me directly to the parent's
child in the Child Informaion.  Also, when in Parent Information, when

I am working in a query.  I have a field called DOB and a field called
Classroom.  I am trying to come

I'm stumped!! How do you get your tabs to go from one page in tab control to
the next page? Right now, when I get to the bottom of the page, it tabs back
to the top. I am using Access 2003 with Windows XP. I want to be able to tab
from one page to the next as I complete my form.

I have a subform with a datasheet default view. One of the fields is a check
box. The check box appears "grayed-out" throughout the datasheet, whether the
value is yes or no.
I've set the default value of the check box to 0, thinking that would make

Does anyone know why I can't use Ctrl Find in a form.  All my other
forms allow me to do so. What am I doing wrong.
Thank you!

I am having an issue with a form that I am hoping someone can help me solve,
or at least point me in a direction so that I can arrive at a solution myself.
Well I guess to begin with I am running Access 2003 on Windows XP.  
My issue is, as stated in the subject line, that I am ...