I am trying to color a subform tab blue or red when 2 of its text boxes are
not null.  Here is my code that I tried but it's not working:
If Forms![Centers of Influence subform].First Is Not Null And Forms![Centers
of Influence subform].Last Is Not Null Then

I have the main form called Table Dados where i enter all data i need and
one of the field, VALUEPREP,  it's suppose to do this :
If [Comis] is FALSE
   then 0

First time poster...I have created a popup form from another form that
includes the following information:
WORK ORDER # (PK)
TECHNICIAN    TECHNICIAN 2    TECHNICIAN 3    TECHNICIAN 4    TECHNICIAN 5    TECHNICIAN

I should know how to do this, but I dont.
When I open my form the main field that everything links to is empy, but the
other field have data from the first record.  How do I get it to open so that
all of the fields are blank and will update once the drop down box has a

I have a menu with a combo box that will open a form with the chosen record
(so the form is based on a filtered query).
I also have another function on the menu that I want to allow me to go to
the last record on the same form.

Hi guys, I am working in an Access Project and I want to connect one textbox
I have in the form with the criteria in the query (View) for the row source
for a combo box in the same form, what I want is for reduce the amount of
records shown in the combo box. I typed this lines in ...

I have a main form calls a second form.
In the second form there is a button I want to exit the second form when the
button is pressed.
What code I should use in the on click event of the button?

I'm trying to convert an Access (adp) application is currently in Access
2000 format to 2007.
I have several subforms with pop-up menus (declared in the "Shortcut Menu
Bar" property with the "Shortcut Menu" property set to "Yes") on subforms

My next problem that I need to address is using a “IF command.
Basically I want the following procedure
IF [companyname] = [1234] then [laborcost] = [hourlyrate] and [laborsell] =
[hourlyratre]

Good Morning to all.
I have a database that i use. i have a table "stock" and a table "materials
subform"
The form i use to write the data to the subform extracts its data from the

I have a field in which I request the employee ID number. The combo box lists
the emplyee ID, their name, department, etc. When I select the employee of
choice, I have the employee ID as the bound column. Is there any way to
display, not save, any of the other fields available in ...

Any one able to forward a template or something that would allow me to create
a purchase order entry screen and then print out a PO from that?  I do need a
field that autogenerates the next consecutive number from the one I tell it
to start with, on each new say, record.  This ...

Here's a tough one.  Currently I have a commandline in txt that opens the
access db and updates the clock on the computer with the internet.  Is there
anyway to simply build this into the access db itself?  Can an access db
fundamently change the clock on the pc (assuming no ...

I have a combo box created in a form for users to search by the "ID" field.  
The ID field is unique and never duplicated.  For example, user types "71" in
the ID field and the record is populated.
Fields in Combo Box:

Is the OpenRecordSet returns the isolated record set or a live record set?
After I called the OpenRecordSet of a table, if someone add a new record to
the same table then does it affect my recordset?
Will this new record also be added to my record set?