Access 2007 ADP, and Sub-Forms

T

Todd C

I just upgraded to Access 2007 from Access 2003. While I am pleased that this
product has native technology to handle configuring SQL 2005 objects using an
Access Data Project (views, etc) I noticed something strange in a
Form/Sub-Form:

The form opens with one Record. No problem there. THe subform is supposed to
display a datasheet with records from the 'Many' side of the relationship. To
do this, I had the Record Source set to a Stored Procedure and the Input
Parameters set as the following: @<ParameterName> varchar(20) =
Forms!<myForm>!<Field>

Now, the sub form show ALL the records in the table, NOT just the ones
related to the parent form.

What gives? Any Ideas?

TIA
 
H

Harlan Grove

Todd C said:
I just upgraded to Access 2007 from Access 2003. While I am
pleased that this product has native technology to handle
configuring SQL 2005 objects using an Access Data Project (views,
etc) I noticed something strange in a Form/Sub-Form:

The form opens with one Record. No problem there. THe subform is
supposed to display a datasheet with records from the 'Many' side
of the relationship. To do this, I had the Record Source set to a
Stored Procedure and the Input Parameters set as the following:
@<ParameterName> varchar(20) = Forms!<myForm>!<Field>

Now, the sub form show ALL the records in the table, NOT just the
ones related to the parent form.

What gives? Any Ideas?
Click to expand...

You are WAY IN THE WRONG NEWSGROUP! microsoft.public.office.misc is
for licensing and generic Office questions (like printing, fonts and
applets). Maybe the simpler Word, PowerPoint and Excel questions get
answered, but this is definitely NOT a newsgroup frequented by Access
experts.

I'm crossposting to microsoft.public.access and setting follow-up to
that newsgroup. Since it looks like you're using Microsoft's browser
portal to the newsgroups, that'd be

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.access
 
T

Todd C

Harlan:

Thanks. I couldn't find the Access Newsgroup for some reason.
It happens.
 
Top