using subform to select records in form

[selahlynch]

I was thinking of using a subform in datasheet view to allow a user to select records on my form. I'd like something similar to a split form, but I'd like to have control of the shape and location of the data sheet part. I could also use a listbox, but I'd like to have all those sort and filter functions that are present in datasheet form.

Anybody ever do this?

Anybody have a different strategy for accomplishing the same thing?

 

[John Big Booty]

This thread may help you to sort the contents of a List Box. It discusses using the On Click event of the List box to sort it's contents, dependent on the location of the cursor within the header row of the list box.