My Unbound Combo Box is a dropdown list of Anthocyanins, Liver Lipids,
Plasma, and ORAC.  The code below always results in the first DoCmd statement
being executed.  In other words, if I update the Unbound box with any word
from the above list, I get the same result.  Could ...

I have a subform for tblFaculty in which the fields Title, FirstName,
LastName, and Suffix are combo boxes based on those fields.  i.e. Title looks
up the values in Title from tblFaculty.
Is there a way I can filter the dropdown menus based on which one has been

I am not seeing anyplace where the fill/background color picker will allow
you to select custom colors with some sore of pallet
so I was just going to enter a number in the "back  color" field of the
properties but I can not seen to determine the format of the colors

I have a form and a subform.  The record source for both is a seperate table.
When I add info to the form/subform the info is added to the table fine.  
The problem is that I only have the option of three forms/subforms.  If I try
to add more it defaults to the first form.  I ...

I was struggling with form filters by selection and  Klatuu (Dave) helped me
with this one and it works great.
me.filter = "[district_name_long] = """ & me.combo & """"
me.filteron = true

i have 6 forms that collects different information about an employee what i
need ot happen is when you save some basic info that is related to the
previous form? how is this accomplished so that when you  add a new employee
to this database you can do it by  filling out the  ...

I have a search text field in the header of my form that I've used in many
other instances to search but for some reason my code wasn't working today.
I've messed around with it a little this morning and seemed to have made it
worse ... it must be one of those days ...

I'm having a problem making the values on a form reset to $0.00 when I go to
a new record.

Using Access 2007 with Vista Ultimate
After creating a new database, when I attempt to create a new form an area
opens up that is not a Form Template.  It will allow me to add controls,
fields & etc but it does not behave like a form.

My set-up is this: I have two tables, one with Employee Name, ID, Date of
Hire, etc., and another table with Employee Logins and Employee IDs.  These
two tables are related through the Employee ID field and there are cases
where an employee has multiple logins, so the ...

I have two forms ADD & VIEW. Each of them have button that will open another
form SERVICE. How can I make to change record source of SERVICE depending on
if it opens from ADD or VIEW?

I'm maintaining a database that was created by someone else.  Ever since it
was created it has had an issue with occasional record corruption.  The data
is being added to header and detail type tables via a form and subform.  The
header table is the table that gets the corrupted ...

I have a form with list boxes. Upon clicking choices on the list boxes, new
records are added in the subform. Each line on the subform (continuous
display) has a button (called DELETE). If the user clicks on this button, the
record on which the button resides is deleted. The ...

I'm trying to build a cbo's Row Source.  When in the query builder I create
my SQL statement
SELECT destinataire FROM (SELECT destinataire,montant_avec_taxes,
CCur(Nz([montant_paye],0)) AS Paye FROM Factures WHERE

I have a basic question about forms (I hope).
I have companies, each providing several different services. I need a form
where data entry clerk can first choose the company from a drop down list and
then all the services that they provide are displayed below (I think I need