Copy From Parent past into Sub Fm

K

KAnoe

I have a sub form that I would like to put a cmd_btn on so that the user does
not need to copy data from the parent form.

I would like to copy the following from the parent form:

Form: Dep Loss add
Field: DEPInDate

And Past it into the following sub form:

Form: DEP Loss Add Sub Fm
Field: DOE

Any help would be great.
 
S

Steve Schapel

KAnoe,

I think code like this will do what you ask.
Me.DOE = Me.Parent!DEPInDate

Having said that, what you are asking is very unusual. Normally it is
not necessary or desirable to duplicate data in this way. It may be
worthwhile to review your design.
 
K

KAnoe

I know but the Parent data can change so I need to keep a record of the old
data. This only happens on abour 10% of my records

Thanks for your help I will give it a shot.

Keith
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Generated text copies into another template 0
Dynamic Naming of Form Button 3
Refer to Sub on Parent Form 3
Linking Child Timelines to Multiple Parents 0
Filter main form to records with no related records in subform,maintain updateable recordset 4
Crating User Form to Add Names 1
Weigh tasks 0
Word VBA Copy Heading and Content 4

Top