Order By Question

[krichard]

Hi...

I have a Timesheet form, that has a subform in it... The main form just has an employee ID, and Name at the top... when i click to the next record, it goes in order of employeeID, but I want it to go in order of Employee Name...

there is no order by in the properties for my code...

Employee ID: [EmployeeID] =[First Name]+IIf(IsNull([First Name]),""," "+[Last Name])

the ID number appears in front of the name... like i have above...

Any help on this would be great!! thanks!

 

[PHV]

What is the RecordSource property ?

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

 

[krichard]

Its "employees" from my employees table.

 

[PHV]

So create a saved query sorted by the Name fieldand use it as the RecordSource.

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

 

[krichard]

That worked!!! Thank you!

I do have one other question... i will post as new question... thanks again!