Access Combo Box - Can't display desired default

[Larry1216]

I have a combo box based on a table going to files for different users.

Wish to display a particular person in the combo box
"Order" field is set as primary but the first record MP is not displayed - another record is instead.

Thanks for Input - did not see this specific item in knowledge base.

Order Reviewer Initials
1 MP
2 EV
3 GR
4 GJ
5 MH
6 SR

 

[Remou]

Tables are not guaranteed to appear in primary key order. I think it is best to add a sort ascending to the field in the query design screen invoked from the properties page for the combo box.

 

[JoeAtWork]

Assuming you have set the combobox's BoundColumn property to 1, try the following code in your Form_Load event:

Private Sub Form_Load()
    
    'Select default 
    If cboMyCombo.ListCount > 0 Then
        cboMyCombo = 1
    End If

End Sub

But Remou's might be the better suggestion.

 

[Larry1216]

Implemented Remou's suggestion on the "row source" line of Control Properties but unfortunately it does not work although it should!

ThankJoes suggestion is beyond my limited technical abilties.

Thanks to both of you for making suggestions. /LMc

 

[TheAceMan1]

How are ya Larry1216 . . .

Post the [blue]RowSource[/blue] . . .

See Ya! . . . . . .

 

[Larry1216]

Row Source = SELECT [Reference 04 MRR Reviewers].[Order], [Reference 04 MRR Reviewers].[Reviewer Name] FROM [Reference 04 MRR Reviewers]

Reviewer Name is what is displayed in the form - the control source is another field with a unique code for each reviewer. "ReviewerCode"

Thanks/ LMc

 

[TheAceMan1]

Larry1216 . . .

[blue]RowSource[/blue] should be:

[blue]SELECT [Order], [Reviewer Name] FROM [Reference 04 MRR Reviewers] ORDER BY [Order];[/blue]

If the above doesn't work please answer all the following:
[ol][li] Is MP in the table [Reference 04 MRR Reviewers]?[/li]

[blue]Reviewer Name is what is displayed in the form - [purple]the control source is another field with a unique code for each reviewer. "ReviewerCode"[/purple][/blue]

[li]In the above quote if the listbox is bound to a field it should display [Order] values! If this is not so, be more specific about this issue.[/li][/ol]

Out of curiosity . . .

[blue]I have a combo box based on a table going to files for different users.[/blue]

Be more specific here too . . .

See Ya! . . . . . .