I have created a Main Form with 4 comboxes where the user can select from one
of the comboxes or make mutiple selection from any of the four, then click
the "Select Button"; where the results are displayed on a subform.
This works fine, however I would like to add a  combox for ...

I have a subform with one record in it.
Allow Additions is set to yes.
When activating the subform to open
it only opens to the blank record. If I

When I pop up a calendar control form, the calendar control defaults to the
date of 4/10/2008 being clicked after the form loads, which is not todays
date.  What setting can I change on the control so that when it displays, it
defaults to today's date as appearing clicked when ...

Given the following code:
Private Sub REGION_LostFocus()
   'change the label to this foreground/background
   'color when the control has focus.

I have a form that does not display correctly.
frm1 opens frm2 via a command button.
My three problems with frm2:
1. Displays in form view when called from the button.

Would someone mind taking a look to seek what order my code should be in.
It's not working.  Right now it is in the control source of field
"associatedname", but I'm thinking it needs to be somewhere else like on
change, enter, before or after....maybe not.

I'm stuck with a Dcount function.  I'm trying to count the number of
choices for a given event where the choice=1.  This is in the EventID
footer of a subreport.  This is what I have:
=DCount("[Choice]","qryEventChoices","[Choice]=1" And "[EventID] = " &

Hopefully this is a simple one. I would like to use a number of form buttons
to send specific PDF documents attached in a table.
The table where the PDF document resides is called [EFORMS]. The table has
two colums [DESCRIPTION] and [EFORM]. Each button on the form would link

I have a form and subform accessed from a non-access driven switchboard.  
The form is for data entry and search.  Included on the main form is a combo
that filters the main form by project owner and a list box that filters by
the project name.  The problem is that when opening ...

I have a subform with 2 "groups" of controls:
IDLengthUOM
IDWidthUOM
IDHeightUOM

I have a subform (service tasks) that when I first create a new record on the
main form (service reports), the subform shows just a blank record (the
subform’s ID is still reading AutoNumber), which is fine, since there won’t
always be a task for every service report.

I have a datasheet with info from multiple tables (SQL). Some of the columns
hold concatenated data based on an id number i.e. the fruit variety column
can hold multiple varieties, or the country of origin column can hold
multiple countries. I need to allow users to be able to ...

I have an unbound combo box as part of a form header, the value in this
control effects the detail contents of the rest of the form.  Due to its
nature I want to put a user warning on this control “Are you sure you want to
change this? - y/n”, sort of thing.  Where the user decides ...

Access 2003
Table name = Members
Primary Key name = CID  (a number)
Field name = LastUpdate   (date/time  Now )

I have a list on my form and I want to print its content even if they don't
appear (i.e. I have to scroll down to see all the elements). Is there a way
where we can print the form and have all the elements of the list printed out
as well?