I have a main form with a subform. The subform also contains a
subform. On the main form is a text box that contains the following
code in the data source of the PrintCount field:
=(DCount("PrintID","tblPrint","FilmNumber =" & FilmID])

How do I copy the value of a field from one form to another form that is not
part of a subform relationship?

I am using Access 2003 and have a form which does some enabling/disabling of
controls as the user keys data.  To avoid screen flicker I set the form's
Painting property to False in the function that handles the enable/disable
process.  I then set Painting back to True before ...

I am a novice at this so I hope this makes sense.  I am trying to apply a
filter to an unbound combo box within the main form 'ArcView_Users' that will
allow me to select a value and filter out only those records in the main form
that contain that value.  The values in the combo ...

I need a piece of code that will allow me to advance to records in a subform
of a subform (main form -> Subform1 -> Subform2, subform of Subform1).  The
following works in Subform1 when it is not within the subform control of the
main form (code is in the Click event of a command ...

I want to know if it is possible to add a film number in a record, and
without exit the form, switch in modify mode to add data in other tables such
actors that are in this particular film. If it's possible, how can I do it ?
I'll be happy even if you have only a general answer.

This code is on the AfterUpdate event of a list box on a popup form.
Private Sub Company_AfterUpdate()
 Dim frm As Form
 Set frm = Forms![LoadSheetsMain]![LoadSheetsST].Form

I am trying to build a report to give a total count of different types of
building inspections. I have two tables. One is called Inspections. It has
among it's fields, InspectionID, Inspector, InspectionType,and InspectionDate.
The other is called Reinspections. It's fields are ...

I've looked through every message here and still have not found an answer to
the following situation.  Please Help.
I have one form (frmClassDetails) that has 2 combo boxes with one dependent
on the choice of the other.

Please Help!!!
I have a form with a tab control and several pages, each have a subform on
it. When I change, or select something in a combo box on the main page, I
want to update the contents of a combo box which is on a subform on the

Thanks in advance
I want to move control to a form from a sub form.
Then to a command button
Can't get code right.  Please help

How can I filter a recordset used in a form record by record
programatically rather than via SQL?
I have a fairly complex vba function that can decide whether the
record needs to be displayed or not in the form but it's difficult/

Using Office 2003 and Windows XP;
Is it possible to remove the title bar of a form so that is just appears as
a rectangle with a frame around it?
I thought this was possible, but I've been experimenting with the properties

I have a set of 4 labels textboxes and buttons. When a button is pressed, I
want to display a msgbox with the label of the textbox in the title. Is there
any way to associate the button with the label?

I have a form with 2 text boxes A and B. A is bound and B is unbound. A is
locked and B is unlocked. All updates are made in textbox B and when the
record is saved B is appended to A.
The problem is that if I enter text in textbox B and then immediately