I have command button in the master form, i would like to write code to copy
the data from field1 to field2 in the subform, consider that i have many
records in the sub form.
i wrote this code

I am working on a database that contains a many-to many relationship.
I created an intermediate (linked) table between the two primary
tables.  I have a Form1 that displays the info from Table1 and a
control to open a Form2 that displays records from Table2 that match

I just installed Access 2007 in my computer, and I followed all the defaults.
I did 'Command Button' on design view, but when I changed to form view and
click that button, it didn't work. I tried to do the other 'command button',
and they all didn't work in Acces 2007.

Access2002 with a popup form that is going to be closed with the red X in its
corner.
The record is dirty   Put into the On Close Event
If IsNull(ImportantField) Then

I have the following code which is supposed to return the StockTakeReportByProductGroup populated by products dependant on the product selected in ListFilter which is a list box containing only the product groups nothing else. This is a text field not numerical. All records are ...

The following code opens a letter (report) for the user to mail out to a
hospital.
The code is from the control button on a form, the form has a subform, and
the user picks from the subform then clicks the button. (code works fine)

I hope I'm able to explain this.  I have a form with a subform.  The form
lists an employee name and subform lists all the training the employee has
had.  In the subform I have a combo box that lists the all workstations
available.  Each employee is trained on a workstation.  I ...

I need to filter a main form based on fields in my subform.  For example, my
main form has a field [Order Number] and the header contains standard
information about the origin of the parts and what is to be done with them,
like the PO Number, and Customer information.  My subform ...

I have use this great forum so many times to help with different issues I
have had.  I am hoping the same will happen this time.  
Here we go:
I have created a form (recordsource [tblProject Staffing Resources]. On this

Using Office 2003 and Windows XP;
I have a form and controls on a multi-page tab control on the form that are
bound to a table.
I need a trigger to fire a subroutine if there is ANY change in ANY of the

Hello. I use Access 2007 with a project (ADP) and SQL Server 2005 Express
Edition. I have a form to add and modify data. I have an unique key that is
video_name. In that form, there is a subform. To be able to complete the
subform, the unique key “video_name” must exist. That is ...

Hello everyone!  Using A02 on XP.
I have 4 reports that contain a series of screenprints providing examples of
how to complete certain forms.  I want to open all 4 in preview with one
button click.  I have this on my button:

I have several different forms using subforms in continuous form view. Some
are calculated controls.
I seem to have problems with Access in continual 'Calculating...' mode, with
the form essentially locked up. Pressing F9 stops this, and all is well and

I’m relatively new to Access so I’m still confused by some of the things
that happen. I have a basic form that calculates elapsed time for my daily
work schedule. Here’s the expression I copied from the Control Source:
=HoursAndMinutes([EndTime] -[StartTime])

I have a form bound to a client list that shows client status and the
assigned salesperson ([assignment] field).  I have placed code in the
BeforeUpdate event of the [status] field that, when the client status is
changed from "active" to "inactive" prompts the user for ...