Sorting records on a form

[Ricardo N]

I am fairly new to Access (2002) and have built a form that has two enbedded
subforms. The underlying table has an AutoNumber P_ID field as primary key. I
want the records to come up ordered by another field, PLName. I set the Form
property Order by to PLName first, and then to tblParents.PLName later and it
still doesn't work. I read another thread where it was suggested to put:
Me.OrderBy = "table.field" in the On Load event of the form. I did that too
and it still won't sort. What am I doing wrong?

Thanks in advance

 

[Ricardo N]

Fred, thanks. It worked like a charm.

Of course I'm still confused as to what purpose the 'Order By' property
serves.

 

[Ken Snell [MVP]]

OrderBy is a property where you can specify the fields and sort order to be
used. After you set the property, you "activate" it by then seteting the
OrderByOn property to True.

 

[Ken Snell [MVP]]

Fred - looks like your PC clock is a little fast.... about 3 hours fast? < g

 

[Douglas J. Steele]

IIRC, Windows defaults to Pacific time if you don't provide it with time
zone information.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

 

[Fred Boer]

Base your form on a query of the table; the query will allow you to set the
order of your records that you need.

HTH
Fred Boer

 

[Fred Boer]

Hi Ken! Thanks... my clock was correct, except for one small thing... the PC
was set for the Pacific Time Zone!? How the heck did that happen? It's fixed
now! Thanks!

Cheers,
Fred

 

[Fred Boer]

That's probably it; I rebuilt this machine a while back...

Thanks!
Fred

 

[Ricardo N]

Ken, thanks for the response. Sorry about the delay.