continue regular program flow (records) after requiry

[Vsn]

Hi all,

I was wondering what the appropriate method would be to just follow the
program flow, while using Me.Requery or SendKeys "+{F9}".

I have a continious form that contains records, in the header on the form
there are some fields which contain statistics on the records shown in the
deatils section. Now if the user completes the input of a record the fields
in the header section need to be updated, and the focus should jump to the
next record (standard). Now if I just keep it going as is, the fields in the
header section are not updated properly, i found Me.Requery or SendKeys
"+{F9}" the only solution to do so programaticaly. But the cursor/focused
record jumps back to the first record in the recourd source.

How can I after the user completed input, just jump to the next record but
update the fields in the header.

I have tried , afterupdate, afterchange, keydown, specific cntrol.reqeury
etc. etc. etc. etc. nothing I get to work as it should.

Any tips are highly appreciated.

Ludovic
--

 

[strive4peace]

Hi Ludovic

"in the header on the form there are some fields which contain
statistics on the records shown in the deatils section"

Do you have equations in the ControlSource(s)? If so, what are the
following properties for these controls?

Name?
ControlSource?


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[Vsn]

Thx to all for advice, for now I found that SendKeys "{F9}" works for me.
However the code posted below looks interesting and I surly will take a
closer look for future projects.

Ludovic