Copy From Parent past into Sub Fm

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KAnoe - 09 Apr 2005 17:15 GMT

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.

Reply to this Message

Steve Schapel - 09 Apr 2005 19:58 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> 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.
[quoted text clipped - 10 lines]
>
> Any help would be great.

Reply to this Message

KAnoe - 09 Apr 2005 20:25 GMT

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

> KAnoe,
>
[quoted text clipped - 19 lines]
> >
> > Any help would be great.

Reply to this Message