I'm making a database that should be very simple: based on a paper-based form
we've been using for a while, there are a lot of detailed questions to which
the user answers "Yes", "No" or "Don't Know" or leaves it blank to come back
to later.

I have a form with 3 unbound combos that lets the user filter data. The
combos RowSourceType = Value List, with 3 values, empty string with label
"don't care", -1 with label "yes", 0 with label "no".
The update event of the combo calls the following code:

I simply want to enter info in a frame (say a customer#) and have other
frames in the same form automatically reflect like info about the customer

Is it possible to create a subform that you can open with an OnClick Event
which, would enable the ability to have numerous subforms attched to a form???
If so, can you help me resolve the issue?
Thank you.

trying to find a basic template for small business operators
if anyone has any suggestions....

I am trying to add validation to an e-mail address in a form field, to ensure
it includes the @ symbol.  I can program the code in Visual Basic using the
OnExit event, and using the SetFocus function to enable the cursor to return
to the form field.   However the Access OnExit ...

I have a form that is bound to a table.There are several unbound cbo Boxes
and I am inserting the value in the the table on the afterUpdate event
me!Field Name = me!cboName
The cbo boxes are Yes/No and 1/0 are stored in the table.

Ok, i have a book and i have a basic understanding of how to use subforms.
However, what i've learned only allows me to edit related information at once.
What i really want is to have a nonupdatable form that only allows you to
look up or view information.

I am trying to create a query and I am getting an error that states:
The expression is typed incorrectly, or it is too complex to be evaluated.....
My fields are as follows:
chrUserID

I've been testing office 2007, and decided that i'd be better off
sticking with office 2003 till a full official release of 2007 is
available. After uninstalling 2007 i now find that all the wizards in
access 2003 won't work. I've tried changing sandbox settings, and

I'm building a form from a query, where I have two tables that have a 1 to
many relationship. When I open my form, it will not let me enter any data
what so ever. Is there a reason for this? Could it be the relationship?

I had originally put code in a subform that allowed the user to type in a
tool number and then, on tabbing out of that field (or somehow losing focus)
it would check to see if the tool number already existed.  if it did, it
would populate the rest of the fields with the ...

I imported data from an Excel spreadsheet (survey data) and wanted to create
a form to make future input of data easier.  However, the wizard says I have
too many fields and therefore the form cannot be created.  
1. What is the limit on the number of fields?

I got an error message when I tried to add more controls on my form.  The
message says "Can't create more controls on this form or report.  If you have
deleted controls from this form, you maybe able to rename the form and add
more controls to it."

This should be easy for someone.  I simply want to be able to enter info (say
a customer #) in one frame and have 2 other frames that show a city and state