Access 2003 Opening form and displaying last record in underlying query

[pgsibson]

Hi Everybody

I want to open a form to add records using a subset of records filtered on a query. eg "department" and then display the last record when query is ordered on "DocumentCode" But don't know how? It just displays the first record in the subset.

Any help would be appreciated
Regards

 

[RuralGuy]

Have you looked in VBA help under GoToRecord?

 

[pgsibson]

GoToRecord

Hi
Yes I have looked at the help. I tried it. But it is a question of where I put the code. If I put the event procedure under "on open" it says can't find the filed name because it is not open and leaves me at record 1 of XXX. I can't think of where else to put it.

I want to display the record so that the last aphanumeric document code can be seen so that the user can create the next one when adding a record.

Thanks for a prompt reply
Regards

 

[RuralGuy]

Use the OnLoad event.

 

[pgsibson]

Got it. Brilliant

Thanks