Automatic page scrolling to the last record

[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

 

[Daniel Pineault]

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.

 

[hobbit2612 via AccessMonster.com]

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

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.

Hi,

[quoted text clipped - 15 lines]

Chris