Sorting of Stock Name in Combo Box

[Guest]

I have 2 tables: 1 is Main stock code and the other is Main historical

the primary key is stock code.

I create a combo box in a form where the user can select the stock name.

How could i sort the list from the pull down combo box from with asscending
order? As i think access have sort the list using the stock code. where is it
not Alphabetic in order if refer back to stock name.

Pls help.

Thank you

 

[Allen Browne]

Open the form in design view.
Right-click the combo, and choose Properties.
On the Data tab of the properties box, click RowSource.
Click the Build button (...) beside the property.
Access opens a query design window.
Use the Sorting row in query design.
When you close the query, answer Yes to the question about updating the
combo's property.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

"Nelson The Missing Lead" <[email protected]>
wrote in message
news:[email protected]...