Exit continuous view subform

I'd like to know if there is a current preferred practice for making movement
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11508-exit-continuous-view-subform.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11508
between continuous view subforms behave the same as it does for moving
between datasheet view subforms, ie. when in the last field of the subform
the user pressing Tab or Enter moves the focus to the next control in the tab
order.

I've googled the problem and found, imho, a rather convoluted solution.
Thought I'd check for something simpler in later Access versions.

tia



*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

I cannot get out of the subform without using Ctl + Tab. Even using the
following code, I remain "stuck" in the first subform:

Private Sub Value_Exit(Cancel As Integer)

Forms![frmShipments]![subInvoices].Form![VendorInvNum].SetFocus

End Sub

That's Microsoft's syntax. And I've used the examples from the Access Web
"How to refer to controls and properties", etc. I don't understand the
problem here.

Mainform: frmShipments
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11508
sub1: subTariffs
sub2: subInvoices
Last field in subTariffs: Value
First field in subInvoices: VendorInvNum




"Ricter" wrote:

> I'd like to know if there is a current preferred practice for making movement
> between continuous view subforms behave the same as it does for moving
> between datasheet view subforms, ie. when in the last field of the subform
> the user pressing Tab or Enter moves the focus to the next control in the tab
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11508
> order.
>
> I've googled the problem and found, imho, a rather convoluted solution.
> Thought I'd check for something simpler in later Access versions.
>
> tia
>
>

On Fri, 16 Jun 2006 0802 -0700, Ricter
wrote:

>I cannot get out of the subform without using Ctl + Tab. Even using the
>following code, I remain "stuck" in the first subform:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11508
>
>Private Sub Value_Exit(Cancel As Integer)
>
>Forms![frmShipments]![subInvoices].Form![VendorInvNum].SetFocus

In my experience you need TWO setfocus events: first setfocus to the
other subform, and only after that setfocus to a control in that form:

Forms![frmShipments]![subInvoices].SetFocus
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11508
Forms![frmShipments]![subInvoices].Form![VendorInvNum].SetFocus

or if frmShipments is the parent form, just use

Parent!subInvoices.SetFocus
Parent![subInvoices].Form![VendorInvNum].SetFocus

John W. Vinson[MVP]

Bingo! Thanks John.

And now I can go back and try to solve an old problem, moving from a subform
on a tab control to a subform on another tab. I have a feeling that two set
focus events might just solve it.



"John Vinson" wrote:

> On Fri, 16 Jun 2006 0802 -0700, Ricter
> wrote:
>
> >I cannot get out of the subform without using Ctl + Tab. Even using the
> >following code, I remain "stuck" in the first subform:
> >
> >Private Sub Value_Exit(Cancel As Integer)
> >
> >Forms![frmShipments]![subInvoices].Form![VendorInvNum].SetFocus
>
> In my experience you need TWO setfocus events: first setfocus to the
> other subform, and only after that setfocus to a control in that form:
>
> Forms![frmShipments]![subInvoices].SetFocus
> Forms![frmShipments]![subInvoices].Form![VendorInvNum].SetFocus
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11508
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11508
>
> or if frmShipments is the parent form, just use
>
> Parent!subInvoices.SetFocus
> Parent![subInvoices].Form![VendorInvNum].SetFocus
>
> John W. Vinson[MVP]
>

On Mon, 19 Jun 2006 0602 -0700, Ricter
wrote:

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11508
>Bingo! Thanks John.
>
>And now I can go back and try to solve an old problem, moving from a subform
>on a tab control to a subform on another tab. I have a feeling that two set
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11508
>focus events might just solve it.

They should. Note that the tab control plays NO role - you simply set
focus to the subform then the control on the subform, you don't need
to reference the tab page or the tab control at all (the right page
will open).

John W. Vinson[MVP]