I need to reference controls and properties on a subform that is two levels
down from the main form.  VBA is on main form is:
Me.SubFormControl.Form.SubFormControl.Form.[control or property]
I get an "Application-defined or object-defined error" message.  

I know several of you are tired of hearing about my vehicle database but bear
with me, I'm almost finished.
I have decieded to add a couple of buttons to my data entry form that will
go to certain records when data is plugged in.  For example, I have a button

On form_1, I have a subform.  I want to access form_2 using data from form1
and its subform.  On the subform 'double_click() I coded:  
Dim stLinkCriteria As String
stLinkCriteria = "([field_a] = """ & Me![field_a] & _

In creating a log that will track each user's entering and exiting the
database, I followed the link provided by Gunny (Thanks so much, Gunny!) -
http://www.access.qbuilt.com/html/session_logs.html
And I've implemented all the necessary steps.  There's only one "oddity" for

I don't understand why I'm getting a "Type Mismatch" with this code.
The only value I'm using is the "ICNNO"
I'm trying to transfer data to a report with: select * from [q_LetterVals]
where [ICNNo] = " & "'" & txtICNNO & "';")

In access 2000, how do I transfer form data to MS Word?.  I would like to use
something like transferSpreadsheet which I use often to transfer data to
Excel.
I would prefer not to create an Access report and then use "Publish with MS

In my form (Items_frm) I have a combo box (Itemcbx) that displays 4 columns
(Item, Makebuy, Revision, IsActive) but is bound to the first column.
However, I would like to pass the other values from the remaining columns to
other fields in my form after the selection. Is this ...

I've written a function (executable through a command bar menu item) that
uses outlook automation to send selected files to an email recipient.  Every
thing is working great, but I would like to see the mailItem, similar to
SendObjects, so that I can type the specific message and ...

I need to hide a column in excel from access. How can I do that?
Alaa

I want to open a form filtered on the ID number selected in a combobox. Using
the button wizard in Access 2007 I don't get the combobox value as an option
for linking fields.
So how can I pass the ID number into the next form (bound to a table) and

Below is an example I found that creates Outlook email and sends. My problem
is I have one user that uses Outlook 2003 and the other uses Outlook
Express. Is there a way to send a email report from Access and allow the
code to send via Outlook Express if Outlook isn't available ...

A query returns seven properties for a list of products: Property1,
Property2, Property3, etc. The properties are assigned to each product by a
combobox for each property on a form. I would like to create a Pivot Table
that displays the products across the top and the seven ...

I suppose I can declare Global variables so that they can be accessed
as soon as an Access project is opened.
I suppose that once declared all forms will be able to access them.
I suppose they must be declared immediately after Option Compare

When the user exits the "MAIN MENU" I've created, I'd like the database, or
better, MS-Access to close.  By making the menu popup and modal, I'm
preventing the user from getting below the menu (to the table links), but I'd
like the db to close when they exit the form - I guess ...

I have a form that has two cascading combo boxes on it. I would like to have
a third combo box that is populated based on the data entered in the two
combo boxes. Here is my current layout
The two cascading combos are “cboModel” and “cboHousing”. The third combobox