In my previous 'JET' based existence I would assign SQL code to a forms
recordsource property to get it to show filtered records e.g.
me.recordsource = "SELECT * FROM tblXYZ Where Code=forms!MainForm!Code;"
where 'me' is a subform. Either this or I would use a query.
Now I have been informed that this is bad karma when dealing with SQL Server
and that I should use a View. But Views don't have parameters, so I started
looking at sprocs. All well and good, but I am unable to assign the
resulting recordset to any corresponding object on a form.
I've found a 'Recordset' property which appears to be totally undocumented,
but that only gives me some vague error about being an incompatible object.
Can anyone point me in the right direction? Actually, come to think of it,
is there a good book that would help with Access Project programming?
Thanks in advance....Pablo