Setting Order By...

  • Thread starter Thread starter Brett
  • Start date Start date
B

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
 
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?
Click to expand...

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
 
Back
Top