Sorting List Box Choices

[suzanne099]

Hello Everyone...

I have been trying to figure out how to sort the data in a list box. (I want the data in the Pick_Batch list box to be sorted by batch_num.) I've tried the following code, but have been unsuccessful.

[Pick_Batch].RowSource = "Select [batch_num], [batch_receive], [count], [tag_batch] From [tbl_batch] WHERE idnum = '" & Me![Pick_Facility] & "' SORT ORDER [batch_num] "

As you can tell from the code, the data populating the list box, Pick_Batch, is based on the choice of another list box (Pick_Facility). Using this code, the list box becomes blank. I am not sure what to try next. Any help anyone could offer would be extremely apprciated.

Thank you.

Suzanne

[JConsulting]

Hello Everyone...

I have been trying to figure out how to sort the data in a list box. (I want the data in the Pick_Batch list box to be sorted by batch_num.) I've tried the following code, but have been unsuccessful.

[Pick_Batch].RowSource = "Select [batch_num], [batch_receive], [count], [tag_batch] From [tbl_batch] WHERE idnum = '" & Me![Pick_Facility] & "' SORT ORDER [batch_num] "

As you can tell from the code, the data populating the list box, Pick_Batch, is based on the choice of another list box (Pick_Facility). Using this code, the list box becomes blank. I am not sure what to try next. Any help anyone could offer would be extremely apprciated.

Thank you.

Suzanne

 
[Pick_Batch].RowSource = "Select [batch_num], [batch_receive], [count], [tag_batch] From [tbl_batch] WHERE idnum = '" & Me![Pick_Facility] & "'  ORDER By [batch_num] ;"
 
 

[suzanne099]

 
[Pick_Batch].RowSource = "Select [batch_num], [batch_receive], [count], [tag_batch] From [tbl_batch] WHERE idnum = '" & Me![Pick_Facility] & "'  ORDER By [batch_num] ;"
 
 

Thank you so much. I guess that was a stupid question. But I was stumped for days.