Show last entry in a subform (without programming)

[Zalina]

I want my subform to show the last entry and I don't know how to use VBA yet. Is there a way to do it without programming? If yes, how? If no, your help with VBA code and hints will be very much appreciated.

[ItsMe]

I suspect you will need to do some programming. I can’t think of any properties that will provide you with the results you need. You will need to provide more info regarding your data to us.

Dedicating a query object to your subform may be the quickest solution. Maybe using some SQL and or expressions in the criteria fields.

What criteria will determine what the last record is? Are you considering one field or many fields? What data type(s) is the field(s)? What are the name(s) of the field(s) and the name of the table?

[Zalina]

Dear ItsMe, thank you for your reply. It happened that I have only now returned to the projekt. I'm gonna learn VBA in the nearest future.