ACCESS FEED: RE: [MS_AccessPros] How Do I open a form and go to the last record

Kamis, 01 September 2011

RE: [MS_AccessPros] How Do I open a form and go to the last record

you're welcome, David ;) happy to help

thanks for the good wishes <smile>

Warm Regards,
Crystal

*
(: have an awesome day :)
*

--- On Thu, 9/1/11, David Tolson wrote:

> Thank you Crystal for the response.
> It worked.
>
>
>
> Have a great day and an even finer day tomorrow.
>
>
>
> r/David
>
>
>
> From: Crystal

> hi David,
>
> on the Load event of the popup form:
>
> '~~~~~~~~~~~~~~~~~~~~~~~~~~
> if me.Recordset.recordcount > 1 then
> docmd.runcommand acCmdRecordsGoToLast
> end if
> '~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> if you want this to be conditional, then use the OpenArgs
> parameter of
> Openform to pass a value that you test and act on
> accordingly
>
> Warm Regards,
> Crystal
>
> *
> (: have an awesome day :)
> *
>
> --- On Thu, 9/1/11, djsdaddy531 wrote:
>
> > Great Day, I have the following code
> > that opens a pop up form
> >
> > DoCmd.OpenForm "frmAddVehicleMake", acFormDS, , ,
> > acFormEdit, , NewData
> >
> > I am opening the form so that the user can double
> check the
> > spelling of a new record that has been added with code
> in
> > the NotInList Event. I do not want the user to have
> to
> > scroll to the last record or click the record
> navigator to
> > the last record. I would like the form to open up to
> the
> > last record. How can I do this?
> >
> > Thanks in advance for the assistance.
> >
> > r/David
> >
> >
>