Setting Order By...

[Brett]

Hello...

What is the correct syntax to use for the form property
Order By?

I thought is was <tblname>.<fieldname>
e.g. tblMember.UserID

So it would look like Order By tblMember.UserID

Would this be correct?

I am using MS Access 2000.

Please advise,

Thank you,

Brett

 

[Bruce M. Thompson]

What is the correct syntax to use for the form property

Order By?

I thought is was <tblname>.<fieldname>
e.g. tblMember.UserID

So it would look like Order By tblMember.UserID

Would this be correct?

If there is only one table in the record source, you need not include the table
name. That's only necessary when you have multiple tables in the form's record
source and you need to remove the abiguity. In either case, however, you *can*
include the table's name, to the following will work:

"Set the desired sort field
Me.OrderBy = "tblMember.UserID"
'To ensure that OrderBy is on
Me..OrderByOn = True

 

[Bruce M. Thompson]

Me..OrderByOn = True

Make that:

Me.OrderByOn = True