Ordering a form based on a table?

Simple question (I think)...

I have a form based on a table and I want it to open with it sorted on
Last Name ascending.

I set the order by property for the form to: tblPersonnel.[Last Name]
ASC
but it opens ordered on the PID, which is an autonumber.

Why does it ignore my order by selection?
Thanks,
Blake

re: Ordering a form based on a table?

gblakewood@gmail.com wrote:Make sure you set the .OrderByOn property as well

Me.OrderBy = MyColumnName
Me.OrderByOn = True

KingOfChi