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

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
>
>