skip patterns thru a module....current forms problem

[sparks]

OK we have it so we can use tables to define skip patterns on our forms.
BUT we can only do one form.
Public Function skipPattern(currentFrm As Form, Optional currentCtl As Control =
Null) As Integer

the current form.

ouch.

this works fine as long as the controls are all on one form.
BUT when they cross to another form we are toast.

how can we pass me for a form that does not have the focus?

I can not see a way to do this. Has anyone done anything like it?

thanks big time for tips, ideas or even a link to some page that shows how or if
this can be done
thanks again for any help

Jerry

[rkc]

sparks wrote:

OK we have it so we can use tables to define skip patterns on our forms.
BUT we can only do one form.
Public Function skipPattern(currentFrm As Form, Optional currentCtl As Control =
Null) As Integer

the current form.

ouch.

this works fine as long as the controls are all on one form.
BUT when they cross to another form we are toast.

how can we pass me for a form that does not have the focus?

I can not see a way to do this. Has anyone done anything like it?

Any form that is open is part of the Forms collection so you can
pass it to your function as Forms("FormName").

[Larry Linson]

"rkc" wrote

Any form that is open is part of the
Forms collection so you can
pass it to your function as
Forms("FormName").

Spl. Note: a Form displayed in a Subform Control is not "Open" and thus not
in the Forms collection. It can be addressed as the Form property of the
Subform Control in which it is displayed.

And, if the form you want is not open, you can open it with

DoCmd.OpenForm formname,.....
Larry Linson
Microsoft Access MVP

[sparks]

On Tue, 28 Jun 2005 03:37:58 GMT, "Larry Linson" <bo*****@localhost.not> wrote:

"rkc" wrote

Any form that is open is part of the
Forms collection so you can
pass it to your function as
Forms("FormName").

Spl. Note: a Form displayed in a Subform Control is not "Open" and thus not
in the Forms collection. It can be addressed as the Form property of the
Subform Control in which it is displayed.

And, if the form you want is not open, you can open it with

DoCmd.OpenForm formname,.....
Larry Linson
Microsoft Access MVP

this sounds like what we are seeing...subforms are not open.

so I just need to keep track of controls on the form and when done, open the
next form on the list and go from there..

thanks will try it..
Jerry

[David W. Fenton]

sparks <sp****@anywhere.com> wrote in
news:h5********************************@4ax.com:

On Tue, 28 Jun 2005 03:37:58 GMT, "Larry Linson"
<bo*****@localhost.not> wrote:

"rkc" wrote

> Any form that is open is part of the
> Forms collection so you can
> pass it to your function as
> Forms("FormName").
Spl. Note: a Form displayed in a Subform Control is not "Open" and
thus not in the Forms collection. It can be addressed as the Form
property of the Subform Control in which it is displayed.

And, if the form you want is not open, you can open it with

DoCmd.OpenForm formname,.....

this sounds like what we are seeing...subforms are not open.

Subforms *are* open -- they are just open as sub-objects of other
forms, not as part of the forms collection itself.
so I just need to keep track of controls on the form and when
done, open the next form on the list and go from there..

You can pass a form reference to your code that refers to a subform.
The form reference for a subform is going to look something like
this, though:

Forms!ParentForm!SubformControlName.Form

That kind of reference can be passed to your function.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc