I'm new to Access and need to know if I can create a form that uses mulitple
combo boxes each based on a seperate table, to create a unique NEW record
that will be stored on yet another "record" table.
To explain the purpose of the form:

I have a main form with a text box that performs a calculation from 2 other
text boxes on the main form. The 2 text boxes get there data from a subform
footer subtotal.
When I have this calculation in the form the form crashes and closes ACCESS.

I know how to do it, I just forgot how or something.....
I need to open a report (I have the command button already) that has two
different criteria to open the corresponding data.
Primary concern -  1. DATE. as in today's date

Private Sub cmdGetReport_Click()
'On Error GoTo Err_cmdMediatorEvalCum_Click
   Dim stDocName As String
   Dim stFiscalQtr As String

I have two toggle controls that each reveal seperate hidden subforms.
Each toggle when pressed will also hide the subform revealed by the
other toggle control. However, this results in both toggles appearing
selected.

I've got a series of nested sub-forms:
(1a) Main Parent
(1b) Sub-form: Header of calendar -- Months, Days of Week, etc.
(1c) Continuous Sub-form: Displays employee vacations

Is it possible to insert text and a hyperlink in an unbound text box?  The
text box provides general information about the form, and if I include the
complete web address, it's displayed as a hyperlink, but I would prefer to
hide all that garbage and have a single word act as the ...

I want to go to a specific record using ClientID, when i do as follows
the code brings up the 706th record Can you tell me how to correct my code?
Thank you,
DoCmd.GoToRecord acDataForm, "frmClients", ,  706

I have a form that where I do not want to allow data entry after 31/12/07
ie., December 31 2007.
In the AfterUpdate property of the [Date] field I have the code:
If [Date] > #31/12/07# Then DoCmd.CancelEvent