goto last record

[soojosie]

Have not worked with access for a long time am trying to update an oldie.
Main form has a sub form. With each new service to customer I select next on the sub forms navigation button. 1 customer might have 6 records on his sub form and another might only have 2.

Problem is that when viewing reports of these visits I need to work on the last service record whereas my sub form always opens to the first record and this is the date read in the reports.

I know it isn’t difficult but I have spent hours on it without success
How can I get the databases to open with all sub forms at last entered record?
Can anyone help ?

 

[MStef]

Hello soojosie!
I can suggest you to make Subform ("Record source" properties) on query (SQL). In query put sort DISCENDING on the date field.
MStef alias Štef

 

[soojosie]

MStef alias Štef

Thank you for suggesting something so wonderfully simple and effective. Today I was thinking I HATE ACCESS, now with that problem solved I realise how much I enjoy working with it when I stop stressing and just play. Thanks for letting me see that too