Display form starting with biggest number

[dalex17]

I would like to know how I can make Acess start with the biggest number each time a form is open.

FYI - The form has a ticket number and some details. When the form opens each time, I want the record with the biggest ticket number to display first.

Dalex17

 

[Rolliee]

use the on_load event to open the dataset as a clone. Then find the max value - or any value and do a:

me.bookmark = rs.bookmark

where rs is the clone recordset.


rollie@bwsys.net

if you wish a sample email and describe this thread.

 

[Trevahaha]

dalex17 --

Questions
---------
Are these tickets deleted upon "completion" or is there a method of storing completion?

If you simply open a form with a recordset set to last record - and the ticket is deleted when done- easy!

However, there will be further if this isn't the case.

Maybe not the simplist, but what I'd do is do a SQL string and ADO

example:

SELECT blah
FROM table
Where tblName.complete = No
ORDER BY tblName.ticket DESC;

then open the form using the record.

rst.open SQL
rst.movefirst

doCmd.open formname,,,"ticket=" & rst!ticket

Let me know if you want me to expand on this.. or if this is ridiculously not what you're looking for!


Trevor

 

[dalex17]

Thanks for the replies.

I have to say that I found your response helpful, but it might be too much of a solution for me.

My question is actually very simple. I just have a table of data that is sorted numerically in ascending order. I just want to be able to show the last record that was entered each time I open the form.

Would it be something as simple as record select = max number (I guess the code or filter would look something like that :0)

thanks,

dalex

 

[Rolliee]

why do you say 'too much' solution?


rollie e

 

[Trevahaha]

ehh.. then just do this:

onLoad()

DoCmd.GoToRecord , , acLast

 

[dalex17]

Yes..that did it! Thanks.

(Sorry if I confused you earlier).

Hey, since your good with easy questions 0), how's about a way to maximise the screen of the form each time it a user opens it?

Thank again for your help on my "load last" issue.

dalex

 

[Trevahaha]

DoCmd.Maximize