How to run a subroutine in a sub-form from the parent

[Richard Hollenbeck]

I have a form that was a stand-alone form which I converted into a sub-form.
On the original form was a close button which did a lot more than just
close. It ran update and append queries (after a VBYesNo in a MsgBox) on
the data in what is now the sub-form. Then it closed. It also runs
functions local to that sub-form. I'd like to just keep everything the way
it is and somehow just call the code from the parent form's new close
button. Here's what I already tried:

"Forms!subFrmEnterGrades!cmdSave_Click"

But I got an error. Access couldn't find the form, though it was right
there in the main form! I was looking right at it. Is there another way to
skin this cat, or do I have to start from scratch?

[MacDermott]

Subforms, even when the main form is open, are not part of the Forms
collection.
Try something like this:
Forms!subFrmEnterGrades.Form!cmdSave_Click
Or
Form_subFrmEnterGrades!cmdSave_Click

HTH
- Turtle

"Richard Hollenbeck" <ri****************@verizon.net> wrote in message
news:NmU4d.12229$464.9727@trnddc01...

I have a form that was a stand-alone form which I converted into a sub-form. On the original form was a close button which did a lot more than just
close. It ran update and append queries (after a VBYesNo in a MsgBox) on
the data in what is now the sub-form. Then it closed. It also runs
functions local to that sub-form. I'd like to just keep everything the way it is and somehow just call the code from the parent form's new close
button. Here's what I already tried:

"Forms!subFrmEnterGrades!cmdSave_Click"

But I got an error. Access couldn't find the form, though it was right
there in the main form! I was looking right at it. Is there another way to skin this cat, or do I have to start from scratch?

[MacDermott]

Oh, and make sure that you change cmdSave_Click to Public, so that it can be
seen from "outside".

- Turtle

"Richard Hollenbeck" <ri****************@verizon.net> wrote in message
news:NmU4d.12229$464.9727@trnddc01...

I have a form that was a stand-alone form which I converted into a sub-form. On the original form was a close button which did a lot more than just
close. It ran update and append queries (after a VBYesNo in a MsgBox) on
the data in what is now the sub-form. Then it closed. It also runs
functions local to that sub-form. I'd like to just keep everything the way it is and somehow just call the code from the parent form's new close
button. Here's what I already tried:

"Forms!subFrmEnterGrades!cmdSave_Click"

But I got an error. Access couldn't find the form, though it was right
there in the main form! I was looking right at it. Is there another way to skin this cat, or do I have to start from scratch?

[Richard Hollenbeck]

Thanks for your help.
I tried both your suggestions and both times got the prompt: "Expected:
=" whatever that means. I double checked the spelling and everything else
is as you gave it to me. Is there any other suggestion?

"MacDermott" <ma********@nospam.com> wrote in message
news:5P***************@newsread3.news.atl.earthlin k.net...

Oh, and make sure that you change cmdSave_Click to Public, so that it can be seen from "outside".

- Turtle

"Richard Hollenbeck" <ri****************@verizon.net> wrote in message
news:NmU4d.12229$464.9727@trnddc01...

I have a form that was a stand-alone form which I converted into a sub-form.

On the original form was a close button which did a lot more than just
close. It ran update and append queries (after a VBYesNo in a MsgBox) on the data in what is now the sub-form. Then it closed. It also runs
functions local to that sub-form. I'd like to just keep everything the

way

it is and somehow just call the code from the parent form's new close
button. Here's what I already tried:

"Forms!subFrmEnterGrades!cmdSave_Click"

But I got an error. Access couldn't find the form, though it was right
there in the main form! I was looking right at it. Is there another

way to

skin this cat, or do I have to start from scratch?

[Larry Linson]

The form displayed in a Subform Control is not Open, and therefore not in
the Forms collection. It exists and is addressable as the .Form property of
the Subform Control.

This code in "frmOrders"

Private Sub Command10_Click()
Me!sbfCustomers.Form.RunFromOutside
End Sub

caused the following code in the Form ("frmCustomers" but name is
immaterial) embedded in the Subform Control ("sbfCustomers") to execute.
This is a form-level procedure -- you may have to change your event
procedure from Private to Public.

Public Sub RunFromOutside()
MsgBox "The code in frmCustomers ran", vbOKOnly, "Test running code
from outside"
End Sub

Good luck with your project.

Larry Linson
Microsoft Access MVP

"Richard Hollenbeck" <ri****************@verizon.net> wrote in message
news:NmU4d.12229$464.9727@trnddc01...

I have a form that was a stand-alone form which I converted into a sub-form. On the original form was a close button which did a lot more than just
close. It ran update and append queries (after a VBYesNo in a MsgBox) on
the data in what is now the sub-form. Then it closed. It also runs
functions local to that sub-form. I'd like to just keep everything the way it is and somehow just call the code from the parent form's new close
button. Here's what I already tried:

"Forms!subFrmEnterGrades!cmdSave_Click"

But I got an error. Access couldn't find the form, though it was right
there in the main form! I was looking right at it. Is there another way to skin this cat, or do I have to start from scratch?

[MacDermott]

You might try Larry's suggestion of using dots instead of bangs.

"Richard Hollenbeck" <ri****************@verizon.net> wrote in message
news:8dV4d.12250$464.2478@trnddc01...

Thanks for your help.
I tried both your suggestions and both times got the prompt: "Expected: =" whatever that means. I double checked the spelling and everything else
is as you gave it to me. Is there any other suggestion?

"MacDermott" <ma********@nospam.com> wrote in message
news:5P***************@newsread3.news.atl.earthlin k.net...

Oh, and make sure that you change cmdSave_Click to Public, so that it can

be

seen from "outside".

- Turtle

"Richard Hollenbeck" <ri****************@verizon.net> wrote in message
news:NmU4d.12229$464.9727@trnddc01...

I have a form that was a stand-alone form which I converted into a

sub-form.

On the original form was a close button which did a lot more than just
close. It ran update and append queries (after a VBYesNo in a MsgBox) on the data in what is now the sub-form. Then it closed. It also runs
functions local to that sub-form. I'd like to just keep everything the way

it is and somehow just call the code from the parent form's new close
button. Here's what I already tried:

"Forms!subFrmEnterGrades!cmdSave_Click"

But I got an error. Access couldn't find the form, though it was

right there in the main form! I was looking right at it. Is there another

way

to

skin this cat, or do I have to start from scratch?