Newbie here! Some criteria to see last Record on my report? (1 Viewer)

[Pat Hartman]

But first I have to learn how to create this macro and “build event”

To the right edge of the event procedure is a button with three dots. Press the button. If you have set the default to always use code, it will create the click procedure and open the code window. Otherwise you get a choice. Choose Code or VBA - I don't even remember what it says. Then it will create the procedure and open the VBA window. BEFORE you do this - MAKE SURE you have given the control a meaning ful name. This one I named cmdOpenReport and the label (on the Format Tab) is "Open Report".

The two lines of code you need have been provided. You just need to change the names to match your control and your report.

You should also watch a few videos. There is no way we can help you with you at your current state of learning. Put a little effort into getting up to speed so you can follow simple directions.

 

[June7]

Review https://support.microsoft.com/en-us...y,macro that the wizard created. ... See More.

 

[soumelaki]

To the right edge of the event procedure is a button with three dots. Press the button. If you have set the default to always use code, it will create the click procedure and open the code window. Otherwise you get a choice. Choose Code or VBA - I don't even remember what it says. Then it will create the procedure and open the VBA window. BEFORE you do this - MAKE SURE you have given the control a meaning ful name. This one I named cmdOpenReport and the label (on the Format Tab) is "Open Report".

The two lines of code you need have been provided. You just need to change the names to match your control and your report.
View attachment 113648


You should also watch a few videos. There is no way we can help you with you at your current state of learning. Put a little effort into getting up to speed so you can follow simple directions.

Thank you very much. now i can make it more clear!

 

[June7]

Or first select [Event Procedure] from property dropdown list then click the ellipsis.