form order by question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
thats what I surmised, I just wanted to know if there was another way.

Thanks for your help,
David
 
Back
Top