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
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
Comment