OpenForm

[JohnM]

Excuse the tail of questions ... thanks for previous answers

DoCmd.OpenForm "FormName", acNormal , , StLinkCriteria, acFormReadOnly

works fine with StLinkCriteria as [NegBehave].[TutorGrp]= '" &
Me![SelectGrp] & "'" (Select gop being from a combo box)

I would have though if i had wanted to sort it I would just add (with a
space) .....

Order By [NegBehave].[" & SortField & "] DESC" (Where sort field is the
field selected by the user.

[Allen Browne]

You can set the sorting after you OpenForm:
DoCmd.OpenForm ...
With Forms("FormName")
.OrderBy = "[MyField] DESC"
.OrderByOn = True
End With

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JohnM" <jo**@jmawer.demon.co.ukwrote in message
news:ej*******************@news.demon.co.uk...

Excuse the tail of questions ... thanks for previous answers

DoCmd.OpenForm "FormName", acNormal , , StLinkCriteria, acFormReadOnly

works fine with StLinkCriteria as [NegBehave].[TutorGrp]= '" &
Me![SelectGrp] & "'" (Select gop being from a combo box)

I would have though if i had wanted to sort it I would just add (with a
space) .....

Order By [NegBehave].[" & SortField & "] DESC" (Where sort field is the
field selected by the user.