Sort Records in Form

[jeffcravener]

I have the records of a table sorted a particular way, but when i bring them in via a form, the sorting is different.

any ideas? I couldn't find a spot in design view of the form to change the sort.

 

[PHV]

Use a sorted query instead of the table as the RecordSource of your form.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jeffcravener]

But, the form will be used to add new records or change them, if you use a query, can this be done too?

 

[PHV]

Sure!
Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886