Sorting records in a form (subform)

[irade92]

Hello
How to sort entered records in a subform by combo box. Notice combo box has integer value not text. I want to bo sroted by text visibled ASC. The code must be in Command control SORT (See pict enclosed)

I have tried something but not very successfull.
Please help

 

[namliam]

Only way is to join your lookup table in the rowsource of your subform and sort on that actual column

 

[irade92]

Only way is to join your lookup table in the rowsource of your subform and sort on that actual column

Thank you a lot for your effort

I solved this in this way:
on Event dblClick of my field "Artikal"" (cboBox) I put this code "docmd.runcommand acCmdSortAscending" and did the job