form order by question

D

dp

Hi guys,

I have a datasheet form that I would like to order by name. However the
name field is not stored in this table. The name field is the 2nd column in a
combo box(ListID, Name). I tried to program it:

me.orderby = me.EmpCbo.Column(1)

This did not work.

Any suggestions?
David
 
J

John Vinson

Hi guys,

I have a datasheet form that I would like to order by name. However the
name field is not stored in this table. The name field is the 2nd column in a
combo box(ListID, Name). I tried to program it:

me.orderby = me.EmpCbo.Column(1)
Click to expand...

Base the Form, not on your table, but on a query joining your table to
the employee table. Include the name field (which I take it you want
as the sort key) in the query, and sort by it.

A combo box *is not data*. It is a display tool. There is nothing
there you can use for sorting!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
D

dp

thats what I surmised, I just wanted to know if there was another way.

Thanks for your help,
David
 
Top