I am having an issue with a form that I am hoping someone can help me solve,
or at least point me in a direction so that I can arrive at a solution myself.
Well I guess to begin with I am running Access 2003 on Windows XP.  
My issue is, as stated in the subject line, that I am ...

Using Access 2003
I am using a form with 6 combo boxes for selecting names. The controls work
as they should to select the names, but I need to do two things before I save
the record;

I am trying to run the following sql from the vba behind a button on a form:
sql = "INSERT INTO tblScorecardActivity (  PaperReqID, ReqTypeID,
ActivityMeasure, BD, IntakeTargetDate ) " & _
 "SELECT " & Me.PaperReqID & ", RequestTypeID, Activities, BD, " &

I have a field that performs a calcualtion based on a date:
Age: ([DATE]-[TR_DATE]).
I need to add to the criteria >50
But the error says Arithmatic overflow error, guess because it was a date

I need to have combo box capability with multi-select ability. I tried using
listboxes, but the problem I have is they don't drop down so I can see only
one listed item at a time. I cannot make the listboxes bigger. Is there any
way to code a listbox to drop-down, maybe by ...

My from displays Members.  That form has a subform that displays Doctors.
I need to add a command button to add Doctors and have them display on the
subform.
When I clisk the command button it opens a form with all my Doctors.

I have a combobox that lists forms to open and does so via an after update
event. Here is the combobox:
SELECT tblProfileTypes.Description, tblProfileTypes.Class,
tblProfileTypes.txtProfileType

I have a form with a flexgrid on it. I plan to place a number of buttons on
the form above the columns of the flexgrid. When each button is clicked I
would like the column below the button to list in ascending order. Any help
on how to code this would be appreciated. Thanks

Help!  I cannot determine why this fails after it succeeds.  
The following code is attached to a button to add a new job and its visits.  
I can select a client and successfully add multiple jobs.  However, when I
select a different client and attempt to add a job I get '2448 ...

I have a code (see below) that keeps receiving a run-time error (2166) that
states "you can't lock a control while it has unsaved changes"...I have in my
code a command that should save the record before it actually locks the field
but for some reason does not seem to work.

I have a form showing data on a given record.  Each record is
potentially linked to zero or more values in a lookup table.  I'd like
to be able to display the data in the link table by using checkboxes
to show if a link exists and to create/delete records in the link

Running Access 2003 on XP, doing a select from a table and passing the
results to this subroutine to update another table.  When running in debug
mode, it works.  When I stop it an anaylze the update statement, copy and
paste into a new query, it works.  Running without debug ...

Is there a simple way to match all values in multiple combo boxes against
four different fields in a table to filter records in a table?
I have a table with patient visit information (tblVisits).  There are four
fields in the table, (Diagnosis1, Diagnosis2, Diagnosis3, and ...

I am attempting to run an update query (a saved query in my database)
from code, and keep getting an error message (3061, Too few
parameters, expected 2).
The SQL of the query is:

Using Office 2003 and Windows XP;
I have a combo box on a form that is set for 2 columns. IT is bound using
the following in the Row Source:
SELECT tblSourceCategory.Source_Category_ID,