I'm great at creating recordsets with Access VB which contain just the data I need.
I'm an absolute dummy when it comes to turning this recordset into a query or table that I can display.
I would like a control like VB's data control where you can assign a recordset to the data control and hey presto there's your data on the screen. But I can't for the life of me find similar functionality in MS Access.
Now I know how to do it the hard way so unless you have a general purpose library function I don't want to know about pain.
Has anyone done this. I've tried many different methods and they're all ugly.