Strange Action using <ctrl>Tab in SubForm

[bw]

In a DataSheet Form, I have the following code:
Private Sub Form_AfterUpdate()
SendKeys "{F7}" 'This spell checks the SubForm
End Sub

When entering data in the SubForm, and go to the next record in the
SubForm using Tab, Enter or Arrow Keys, everything works well.

If I make a change to a field, but DO NOT press Tab, Enter or Arrow Keys
to go to the next record in the SubForm, but instead use <ctrl>Tab to go
to the next record on the MainForm, the following happens:

1. The SubForm record is indeed updated.
2. The AfterUpdate event DOES NOT get executed.
3. The mouse arrow changes to a "Cross" and has selected the MainForm
to allows the mouse to "Move" the MainForm.

Can someone explain what's going on here?
How do I make the AfterUpdate event get executed if I use <ctrl>Tab to
go to the MainForm?

Thanks,
Bernie

 

[Marshall Barton]

In a DataSheet Form, I have the following code:
Private Sub Form_AfterUpdate()
SendKeys "{F7}" 'This spell checks the SubForm
End Sub

When entering data in the SubForm, and go to the next record in the
SubForm using Tab, Enter or Arrow Keys, everything works well.

If I make a change to a field, but DO NOT press Tab, Enter or Arrow Keys
to go to the next record in the SubForm, but instead use <ctrl>Tab to go
to the next record on the MainForm, the following happens:

1. The SubForm record is indeed updated.
2. The AfterUpdate event DOES NOT get executed.
3. The mouse arrow changes to a "Cross" and has selected the MainForm
to allows the mouse to "Move" the MainForm.

Can someone explain what's going on here?
How do I make the AfterUpdate event get executed if I use <ctrl>Tab to
go to the MainForm?

Trying to figure out what SendKeys does is a ridiculous
exercise. Don't use it!

Use DoCmd.RunCommand acCmdSpelling instead. If the text in
a text box is selected it will operate on just the text
otherwise it should(?) operate on all of the active form's
data.

 

[bw]

Trying to figure out what SendKeys does is a ridiculous
exercise. Don't use it!

Use DoCmd.RunCommand acCmdSpelling instead. If the text in
a text box is selected it will operate on just the text
otherwise it should(?) operate on all of the active form's
data.

That works!
Thanks Marshall
Bernie