Network Group Policy causes form-datasheet requery

  • Thread starter Danny J. Lesandrini
  • Start date
D

Danny J. Lesandrini

Has anyone else noticed this behavior?
Focus jumping from current cell to upper left in embedded datasheet.
If not, would you be willing to test your environment and report back?


I posted this question back in May because a client using our application
reported it. We could only reproduce it on our network if we modified the
configuration. Now, however, it's happening all over the place.

A link to the original post is shown here, but I'll rephrase the question below ...
http://groups.google.com/group/micr...75b59?lnk=st&q=&rnum=2&hl=en#d466e949b9275b59


Problem:
--------------------------------------
Parent form with record source has an embedded subform that is linked
on Master/Child fields. Subform is a datasheed with multiple rows visible.
Without warning, the screen flashes and the focus jumps to the first row,
first column.


Steps to Reproduce:
--------------------------------------
1) Open any form with a datasheet subform linked on Master/Child fields
2) Place cursor in any cell, down a few rows and over a few columns
3) Open a command window and execute this: gpUpdate /force
(this forces update of the network group policy)
(answer no (N) to prompts to reboot and logoff)
4) Watch the cursor in your datasheet subform jump to top left cell.


This may not happen to you. We worked with Microsoft on this for weeks
and got no resolution. Suggestions were made of how we might redesign
our forms, but they didn't help.

Our client tracked it down to a network group policy setting for IE and
since their draconian approach to security forced the update every 5 mins,
their users were going nuts with the cursor jumping out of their boxes all
the time. Not to mention that it promotes data entry errors

I'd appreciate hearing back from anyone who can reproduce this. If we get
enough of us, maybe Microsoft will be forced to figure it out. The only solution
we could come up with was to change the group policy refresh from its default
of 90 minutes to 12 hours ... but that seems like a kludge.

Thanks
 
B

Brendan Reynolds

I never use the Link Master Fields and Link Child Fields properties, Danny.
My subforms use queries such as: "SELECT * FROM SomeTable WHERE SomeField =
Forms!MainForm!SomeControl". I wasn't able to reproduce the problem using
these forms. Was that one of the design changes Microsoft suggested?
 
D

Danny J. Lesandrini

Brendan:

That's a good thought. I'll give it a try. But you may not be able to reproduce
it because you're group policies aren't whacked. We couldn't, until 3 weeks ago.
Our client saw the problem 6 months ago, but something changed on our network
and the admin can't figure out what it was.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top