Very Computer

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

You can take a look at kb article 301987 for more info about the recordset
property.

Hoping it may help,
Vanderghast, Access MVP

Quote:> 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