ComboBox to acend by phone number...

[Casper2012]

I have a combo/lookup box in my form that allows me to search by phone number and populates fields for me. My question is, how can I show my phone number to list in accending order?

******************************

Private Sub cboNames_AfterUpdate()
If Len(Me![cboNames].Column(1)) > 0 Then Me.txtPhone = Me![cboNames].Column(1) Else Me.txtPhone = " "
If Len(Me![cboNames].Column(3)) > 0 Then Me.txtLastName = Me![cboNames].Column(3) Else Me.txtLastName = " "
If Len(Me![cboNames].Column(2)) > 0 Then Me.txtFirstName = Me![cboNames].Column(2) Else Me.txtFirstName = " "
If Len(Me![cboNames].Column(4)) > 0 Then Me.txtProductFrom = Me![cboNames].Column(4) Else Me.txtProductFrom = " "
End Sub

*******************************


thanks!

 

[RuralGuy]

The RowSource of a ComboBox can be a query and a query can sort on any column in any order.

 

[Casper2012]

I understand they can be query's, I already had a source query for this form. This script is running on the page, just wondering how to filter so that my phone numbers are showing is a list order...

thanks in advanced!

 

[RuralGuy]

I'm talking about the RowSource of the ComboBox, not the RecordSource of the Form.

 

[Casper2012]

Ahhhh.... I see whatya mean.

Boy I feel stupid, right there in front of me the whole time.. LOL


Thanks Rural!

 

[RuralGuy]

Glad we could help.