Sandra helped with my last problem about 2 hours ago then I stumbled into
another problem.
My main form with 3 sub forms. I have an option group on sub form 2.
Depending what that answer it Enable's fields on sub form 3. I cannot get the

I have a form that has an image as the main item on it. th image is an
exploded schematic of an appliance with parts references on it.
The problem is that I have placed labels over the parts references and on
the click event of the label the following code runs.

If I have several tick boxes and want the user to tick only one of
them, how is it possible to generate the result into a report.
Basically I want to be able to convert the tick box to text. This is so
that grouping within the reports is easier.

Does any have a script to attach files on my network to specific records in
an Access database?  The file names are in this format P1_0001.txt and the
record it needs to attached to is 1.0001; the next file name would be P1_0002
and the corresponding database record is 1.0002, etc.. ...

I have a yes/no checkbox on my main form. This yes/no checkbox is to indicate
if there are any safety violations.  If the user selects "yes" a subform is
enabled for the user to select the violations.  The problem I am having is
when users select "yes" they are not selecting at ...

I have a main form with 3 sub forms on it each on different tabs. On the load
of the Parent form (frmaaMain) I have some fields on sub form (tblEnd) become
disabled. The code looks like this.
Option Compare Database

When the user changes tabs in a form I want the On Change Event to make
particular controls on the main form visible.
I tried:
Private Sub TabMainTab_Change()

My user wishes for me to color code data entered, however not all data using
the same textboxes, etc can be the same color.
Any way to resolve this or should I tell the user we need to figure out
another way to show the data.

I'm having trouble spanning lines for a docmd.runsql statement. Here's a
snippet of my code (there are several more fields to update, so the "SET"
keeps going on...and on... and on):
DoCmd.RunSQL ("UPDATE [MEC Demographics], [MEC Data] INNER JOIN qryLimitData

I have a main form and a subform.
In the subform (continuous form) there is a field [text15] that summarises a
field in the subform. The control source of [text15]  =sum([asubformfield])
In the main form i want to use this value to do some other calculations.

I have an unspecified number of tables that will all need the same bulk
update query run. They have the same field names to update, so I just need to
be able to change the corresponding tables.
I'd like to be able to select the table in a form and then have the query

I'm have problems with code below as when I run it I get a 3061 error "Too
few parameters. Expect 1." I believe it is choking on the Me.txtValueof in
the WHERE clause.
What am I missing?

I've got a database used by several people, and I need a way to
automatically mark who added and/or changed a record.
Is there a way to do this other than making them enter some kind of ID? I
really need something that will work in the background. It could key from

I got the VBA query set up so that it works with you selecting a field name
from a combo box and typing in the data to search for in the text box next to
the combo in the form.
Now I need to make it so partial matches show up when they search.

After spending a fair bit of time searching the forums, I have finally
given in.  I have a form that contains 3 subforms.  The subforms are
all based on queries.  The subforms contain a set of combo boxes
(basically used to asign a value of Pass/Fail).  I can tab out of the