Copying Data

[Andrew]

Hi,

I have a form that shows a job (computer maintainence system) i have a
button that opens another form that allows the user to log a call to
the manufacturer from the log form. I need access to copy the ID value
found in the 1st form into the 2nd form when it opens. how can you do
this?

cheers

[Rick Brandt]

Andrew wrote:

Hi,

I have a form that shows a job (computer maintainence system) i have a
button that opens another form that allows the user to log a call to
the manufacturer from the log form. I need access to copy the ID value
found in the 1st form into the 2nd form when it opens. how can you do
this?

cheers

If the second form is always opened from the first just set the DefaultValue
property of the ID control to...

=Forms!NameOfFirstForm!ID

If not then you can use...

DoCmd.OpenForm "SecondFormName"
Forms!SecondFormName!ID = Me.ID
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Ed Robichaud]

This is usually done by "linking" the forms. In the code that opens Form2,
add the link criteria, like:

Dim DocName As String
Dim LinkCriteria As String

DocName = "mySecondForm"
LinkCriteria = "[myID] = Forms![myFirstForm]![myID]"
DoCmd.OpenForm DocName, , , LinkCriteria
If you use the toolbox wizard to create your command button, it will walk
you through the steps.
-Ed

"Andrew" <mc******@hotmail.com> wrote in message
news:5f**************************@posting.google.c om...

Hi,

I have a form that shows a job (computer maintainence system) i have a
button that opens another form that allows the user to log a call to
the manufacturer from the log form. I need access to copy the ID value
found in the 1st form into the 2nd form when it opens. how can you do
this?

cheers

[Rick Brandt]

Ed Robichaud wrote:

This is usually done by "linking" the forms. In the code that opens
Form2, add the link criteria, like:

Dim DocName As String
Dim LinkCriteria As String

DocName = "mySecondForm"
LinkCriteria = "[myID] = Forms![myFirstForm]![myID]"
DoCmd.OpenForm DocName, , , LinkCriteria
If you use the toolbox wizard to create your command button, it will
walk you through the steps.
-Ed

That will open the second form filtered to show existing records with the
matching key field from the first form, but it will not cause any NEW
records created in the second form to inherit that key value.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com