form order

[vicsaccess]

ok, this should be a simple question but since I'm learning as I go I like to come here for suggestions. I have a form with two control buttons that allow the operator to scroll thru the shifts. this is based upon the primary key and actually I show it to him but have it locked so he can't mess with it. it automatically defaults to assenting order which forces the user to scroll thru all his shifts from the start. can I change a setting or something to have this open to the last record or descending order?

[vicsaccess]

Database71.zip
attached is the example. I would like the production page to open to the newest record instead of the first. please help

[pbaldy]

You can base the form on a query that includes the desired sort, or set the Order By property of the form. I'd probably do the former.

[vicsaccess]

Thanks pbaldy. I like simplicity so what would I set the order by property to, descending?

[pbaldy]

One way, in VBA:

Private Sub Form_Load()    
  Me.OrderBy = "DailyProdID DESC"
  Me.OrderByOn = True
End Sub

[vicsaccess]

thanks pbaldy, working in vba in new to me. do I just copy and paste into the order by property?

[pbaldy]

No:

http://www.baldyweb.com/FirstVBA.htm

[vicsaccess]

ok, here's something new. the code worked great pbaldy but currently the DB's are all for a individual/machine and i'm going to a split DB design with multiple people on the single DB. how do i modify the code per line? here's my SQL if i do it that way-
SELECT DailyProductionT.DailyProdID
FROM DailyProductionT
WHERE (((DailyProductionT.LineID)=[Forms]![DailyProductionF]![LineID]))
GROUP BY DailyProductionT.DailyProdID
ORDER BY DailyProductionT.DailyProdID DESC;

[pbaldy]

I would expect that SQL to still work, presuming each user has their own copy of the front end, which is the normal setup.

[vicsaccess]

yes, each user will have their own copy of a front end. i'll give it a try, thanks again.

[pbaldy]

No problem, post back if you have trouble.