Copy information

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PieterZ - 20 Mar 2005 15:23 GMT

I'm trying to create a command button that will copy information in 2 fields
simultaneously from a form to a subform. I found an example in another
database that looks like this:

Private Sub cmdEnter_Click()
[strDescr] = [Forms]![frmEqpt]![strType]
[intICN] = [Forms]![frmEqpt]![intPartNum]
End Sub

If I use this, I get an error "cannot find [frmEqpt]".
If there is a better way to do this, please help.

Signature

Pieter Z

Reply to this Message

Rick Brandt - 20 Mar 2005 16:42 GMT

> I'm trying to create a command button that will copy information in 2
> fields simultaneously from a form to a subform. I found an example in
[quoted text clipped - 7 lines]
> If I use this, I get an error "cannot find [frmEqpt]".
> If there is a better way to do this, please help.

Where does this button reside? Is frmEqpt an open form when you run this code?

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

PieterZ - 20 Mar 2005 18:23 GMT

frmEqpt is a subform on the form in which the button is situated.

> > I'm trying to create a command button that will copy information in 2
> > fields simultaneously from a form to a subform. I found an example in
[quoted text clipped - 9 lines]
>
> Where does this button reside? Is frmEqpt an open form when you run this code?

Reply to this Message

Rick Brandt - 21 Mar 2005 14:57 GMT

> frmEqpt is a subform on the form in which the button is situated.

Subforms are not technically "Open" which is why your syntax doesn't work.
You need to reference it by going through the parent form and then its
subform control.

Forms!NameOfParentForm!NameOfSubformControl.Form!intPartNum

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message