Thanks to all those who answered the numerous queries about cascading combo
boxes.
I was able to set up three boxes in my form where the input in the preceding
box selects the values available in the next.

I have an Audit database where I need to display the amount of non
conformances raised. The non conformances are raised in a sub form linked to
the main form. How can I get a "record count" of the sub form into the main
form?

I have a database with a timesheet form that I'm reporting StartTime,
EndTime and ElapsedTime.  ElapsedTime is calculated using a HoursAndMinutes
minutes function: =HoursAndMinutes([StartTime]-[EndTime]) for each record
and then a total time for the employee:

I am creating a data entry form for accidents and other types of unusual
incidents. I already have a form for the initial incident entry. I am now
trying to create a form that will list all incident data plus a sub-form that
displays all the follow-up detail that goes with each ...

I have an unbound text field on a form, for a persons name...
Supervisors will fill in the form, then press a button to email a copy to
our front office...
I know you can't email a form, so I set up a report that looks similar to

Is it possible to set an After Update on my combo box for 2 things.  I have a
form with a combo box of Client names from my Clients table.  It's set up to
update the Client ID field after selecting the Client name.  
Private Sub ClientNameCombo_AfterUpdate()

I have a form I'm trying to create to enter grants. I have a table for grant
organizations, for applicants, for applicant organizations and for grants.
I'd like to be able to pull the name of the applicant organization from that
table when I enter the name of the applicant in the ...

Hello! I'm looking for design suggestions for a new feature I want to add to
my School Library application.
The feature allows the user to create a "Book List" report. The process is
as follows:

When I bring up the Time Card Form, the time card name in bold at the top
does not change to reflect the employee chosen.  Does anyone know how to
correct this?

I'm maintaining an existing Access database, and have come across a form
that, upon open, is scrolled down approx. 1/4 inch.  I can't find any
form property, or any code behind the form, that would make it behave in
this manner.  I'm sure I'm missing something, but don't know ...

I have a table with people, with each person having a unique ID, and person
information. Then there is a table with courses. Each row is supposed to have
the ID of a person from the person table, and the name of the course, and
other course information. The tables are linked in a ...

I have a text box month id in my form.  When I am making a report, I want
month to come out as a number so I can sort them.  Is there a way to put an
if statement in there in VBA or somethin else to where I can say for example,
If month=January in my table, then month id =1?

I have created a form which has multiple listboxes.  I can get the associated
query to run only when one or more selections have been selected in the
listboxes.
In some cases, a list box may not have a selection and I want all the data

Help!  We have an Access Database (2000) that we have created.  We are
working on the last pieces of it...getting the forms together.  It is a
simple database of participant info, attendance, and department tables.
The form we are trying to create is the attendance form.  This ...

I would like to create a splash screen where you will see a form briefly with
the company logo and then move straight to another form for example the
switchboard, how do I do this.
Hope someone can help