Help with sorting records on a continuous form.

[JoeHank]

Hello, I'm using a continuous form who's RecordSource is a table that contains several foreign keys. Is it possible to sort the records on the form by fields in the foreign keys table. Thanks for taking the time to read this request.

 

[SgtJarrow]

Change the recordsource of the form to a SQL statement that matches the table connection and include a ORDERBY clause where necessary....change this ORDERBY as needed and requery.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[JoeHank]

Hello mstrmage1768,

Thanks for the good advice.