From: Tony No Baloney on
I have an Access subform issue which a friend submitted to me, and I
am stumped.

There is a "Main" template with tables, forms and subforms connected
to it, built relationships, etc.

She wants to keep the "Routine" subform that was activated on the
"Main" main form (which she renamed "Applicants" - maybe this is part
of the problem?).

Now whenever she clicks on the "Routine" button, I get an error
message that says, "Open the Routine form using the Routine button on
the Main form." An endless loop?

If you have any ideas how to remedy this, please advise.

From: Tom van Stiphout on
On Tue, 15 Jun 2010 19:01:27 -0700 (PDT), Tony No Baloney
<tonyrulesyall(a)yahoo.com> wrote:

Please post the code in the Routine button Click event.

-Tom.
Microsoft Access MVP


>I have an Access subform issue which a friend submitted to me, and I
>am stumped.
>
>There is a "Main" template with tables, forms and subforms connected
>to it, built relationships, etc.
>
>She wants to keep the "Routine" subform that was activated on the
>"Main" main form (which she renamed "Applicants" - maybe this is part
>of the problem?).
>
>Now whenever she clicks on the "Routine" button, I get an error
>message that says, "Open the Routine form using the Routine button on
>the Main form." An endless loop?
>
>If you have any ideas how to remedy this, please advise.