open form and show most recent record (1 Viewer)

kobiashi · Sep 24, 2018

hi

this is probably the most easiest thing to do, but i cannot find and answer

i would like to open a form with the most recent record from button click

ive found how to load the most recent record, but that requires the form to already be open

Gasman · Sep 24, 2018

I use this in the load event of one of my forms

Code:

    DoCmd.RunCommand acCmdRecordsGoToLast

kobiashi · Sep 24, 2018

Gasman said:
I use this in the load event of one of my forms

Code:

DoCmd.RunCommand acCmdRecordsGoToLast

thank you, didnt occur to me to execute it on the form, was trying to do it from the button.

missinglinq · Sep 24, 2018

Gasman said:
Code:

[B]DoCmd.RunCommand acCmdRecordsGoToLast[/B]

Wouldn't that be problematic if the Form is Sorted and the last Record entered was not necessarily the last Record when the Form opens?

Linq ;0)>

kobiashi · Sep 24, 2018

missinglinq said:
Wouldn't that be problematic if the Form is Sorted and the last Record entered was not necessarily the last Record when the Form opens?

Linq ;0)>

I run and append query to create a new entry from a button, that also opens the form.

Sent from my ONEPLUS A6003 using Tapatalk

Gasman · Sep 24, 2018

Well not for me, as I just want to see the last 5 records and then generally add a new record.
As it also has a Emulated Split Form as a subform, the source is set on form open.

missinglinq said:
Wouldn't that be problematic if the Form is Sorted and the last Record entered was not necessarily the last Record when the Form opens?

Linq ;0)>

open form and show most recent record (1 Viewer)

kobiashi

Registered User.

Gasman

Enthusiastic Amateur

kobiashi

Registered User.

missinglinq

AWF VIP

kobiashi

Registered User.

Gasman

Enthusiastic Amateur

Similar threads

Users who are viewing this thread