how can i make my form . close when  i press the escape key
thanks

I have a form with a checkbox; I'm trying to build a query that grabs that
value from the checkbox (-1), and use it as a criteria. In the criteria, I
want to say: if the checkbox is checked, give me all records that do not have
a -1, otherwise give me all records.

i have a field on a form which calculates and displays the number of records
(using the 'count' expression).
when I open the form as a standalone form, the field displays correctly; but
when I open the form as a subform of another form, it says #error.

and want to be able to change the font color of items in the tree based on
certain criteria.  Also, I would like to display information about the item
highlighted on the tree control onto another part of the form by passing the
value of the item on the tree control into the forms ...

Does anyone know how to eliminate the buttons of searching, filtering,
sorting in access 2007 forms?
Thank you in advance,
V.

in a form I use the following working expression:
Dim strVersion As String
strVersion = 20080219
... If DMax("[Version]", "[fileversion]") = strVersion Then

I am working with Access 2003.  I have a main form and subform.  My subform
is in datasheet view.  I would like to know if in a subform - datasheet view
you can freeze the column headings so that when you scroll down you can keep
the column heading? (like in Excel you can freeze ...

I have import an application I developed in Access 2003 to Access 2007.   All
of my forms are now showing up full screen with a tab.  Even the small forms,
such as the CopyRight, which is supposed to be a small  2” by 3” window.  It
now takes up the full screen with a tab and my ...

I have designed Databases for many years now, but never attempted this:
I need to know how to create an email with information located in the active
form or off of a query. I would like to have the email automatically
generated with the To Address, The Subject Line and the Body ...

Each customers is sent to us from a salesman, and we provide service for 1-7
days before the activity ends.  A new charge is generated for each day of
service.
Employee #1 uses the customer service form to generate a bill, and includes

Background:
In my main table, I have a field that must be completed before they enter a
new record.  I selected "Yes" under the General Tab labeled "Required".
Question:

On my form I have "Model" linked to "Model" on my subform.  My subform data
source is a select query.  It works well, but the subform will not update
until you step off the record.  I am trying to update my subform when I
change the Model selection.

I have a form with an unbound text box whose row source type is this select
query:
SELECT CheckFinalPercentages.AllocType, CheckFinalPercentages.[Master-Sub],
CheckFinalPercentages.SumOfPERCOUT AS Pct FROM CheckFinalPercentages ORDER BY

       Mark woke me up to how to select a record in a multiselect listbox, but
if the record I select is way down the list, how do I make the list scroll
down so it's shown?
- Max

I have form with several unbound textbox controls.  I wish to limit the
number of characters in one control and specify an exact number of characters
in another.
I can not figure out the method to create this type of validation.