Automatic page scrolling to the last record

  • Thread starter Thread starter hobbit2612 via AccessMonster.com
  • Start date Start date
H

hobbit2612 via AccessMonster.com

Hi,

I wonder if someone can help me please.

I'm using the code below on a subform where upon opening the form
automatically scrolls to the last page on the form. The code is set on the
'On Current' event.

'DoCmd.GoToRecord , , acNewRec'

The problem is, is that say for example I need to check a previously keyed
record on the form it will not allow me to click on any field within that
record.

Has anyone any ideas please.

Many thanks and regards

Chris
 
You will need to remove your code from the subform and code the OnCurrent and
OnOpen event of the parent form to perform the action on the subform. Thus,
the subform will allow navigation.

If you need more help just let me know.
 
Daniel,

Thanks very much, this has worked a treat.

I knew that it would, or should I say hoped it would be something straight
forward, but couldn't fathom out what the solution was.

Once again many thanks

Chris

Daniel said:
You will need to remove your code from the subform and code the OnCurrent and
OnOpen event of the parent form to perform the action on the subform. Thus,
the subform will allow navigation.

If you need more help just let me know.
[quoted text clipped - 15 lines]
 
Back
Top