Forum Discussion
Multi-Select List Box - sort when transferring values to field/row
Thanks for your reply. I'm not an expert on VBA, but I have written code for several databases.
I've read numerous posts about list boxes and arrays. I've seen a number of code blocks online but can't work out which one is best for my scenario. I guess I need a two-column array (one being the sort column). Would the array function need to be behind a button on frm_Resources? Would frm_Resources need to be Unbound?
Working out how to approach problems like this is a one-off for the most part. In fact, as an aside, one of the reasons responding to questions like this is that every situation is different in some ways, so there is no "out of the box" code that can be passed along and dropped into a module.
Arnel has demonstrated an ability to create code for specific situations, in the past. In a more generic one, it's going to be tough to do, though. If you can provide table and field names and perhaps screen shots, I'd be willing to bet a basic framework would be easier to suggest.