Sorting of Stock Name in Combo Box

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

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
 
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]...
 
Back
Top