find record using combo

[alxj]

Now this is probably staring me right in the face but...

I have an orders form (Usual stuff main = clients, sub = orders, subsub = products,{all query based})
on the main i have created a combo that finds a company name from the records in the table, this works fine however whenever i add new clients they appear as the last selection (i am guessing this is due to ordering by clientID number rather than a-z by company name). My Clients Query orders ascending Company Names but this make no difference.

Some of our clients have different depots so this order method would be a huge time saver.

Thanks Alex

 

[Skippymouse]

I had a similar problem myself, fortunately it is pretty easy to fix. Here's what I did.

In the property box for that control on the form I went to the data tab. In the tab is the RowSource. By clicking to the right of that line you will get a "..." box. Click it. It will give you a SQL query grid. Select the control from the source table and order ascending. Then save and name it. The name of the newly created query will show up in the box. What it does is create another query that only does this one thing. It is pretty slick and does not require coding! Your list should be in ascending order from then on.

Good luck