Making a button that scrolls to the bottom of a form

[Phil M.]

I have a form and a subform:

I want to put a button in the form, that makes the subform scroll completely
to the bottom.

Is it possible to do this in VB or something?

Thanks
Phil M.

 

[M.L. Sco Scofield]

Try putting this in the click event of a command button:

sfrmContainer.SetFocus
DoCmd.RunCommand acCmdRecordsGoToLast

Where sfrmContainer is the name of the Subform/Subreport container.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue
Miscellaneous Access and VB "stuff" at www.ScoBiz.com