
Passing Parameters to stored parameter queries using VB 5's Data Controls
See my reply to "VB6 and ACCESS ..... HELP". Same general principle.
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please post/reply to the newsgroup(s) so
that everyone can benefit from the discussion.
Regards,
Klaus H. Probst, MCP
ICQ: 22454937
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Quote:
> Hi.
> I have a Data control in a VB5 program to manage the main table (Businesses)
> and then i'd like to use a data control with a subquery to show all the
> contacts for that business. The way im doing it right now is changing the
> .recordsource property of the subquery data control every time the main data
> control is repositioned.
> Is there a way to use stored parameter queries in an Access database,
> instead of having to type the SQL in the .recordsource property?
> Thank you in advance,
> Nuno Ferreira