Copy into new field on new form

[Anthony W.]

I have a form and on my form i have a control button that
when pressed opens a another form. Is it possible to have
code so when the form opens it would copy information from
fields in the previous form and paste them into the form i
have just opened.

The reason being, when trying to add new records to my
second form, the primary key fields are not being updated.

If so, how please?

Thanks in Advance


Anthony Webb.

 

[Howard Brody]

Easiest way to do this is have your CommandButton:
1> open the new form
2> reference the original form to populate the fields on
the new form
3> close the original form

Hope this helps!

Howard Brody

 

[Todd D. Levy]

In article <[email protected]>, hbrody@cable-
express.net says...

Howard,

I have a similar situation.

Could you provide a piece of sample code for demonstration purposes?

In my case I only want to copy the value from a single field in the
form/table where the command button is to the form/table that is opened
by the command button.

If possible I would like to first form to remain open (in the
background) while the second form is being used.

Regards,

Todd