Filter critiria based on data within a form

[8177]

Hi

Im new to Access Data Projects and im having an issue trying to get return data from a query based on data within a form can any body help

In MDB I would use [forms]![Form1]![ComboGroup] for example

I have looked at previous threads and tried to emulate them however still can’t get it to work

I have added to the input parameters on the data tab @group=[forms]![Form1]![ComboGroup]

And in the stored procedure I have added
ALTER PROCEDURE midasuser.qstpProjects
(@Combogroup nvarchar(50))
AS SELECT qselActiveABCProjects.Name AS MainProject, qselSubProjects.Name AS SubProject, midasuser.dbo_Groups.Name AS GroupName
FROM midasuser.qselActiveABCProjects() qselActiveABCProjects INNER JOIN
midasuser.dbo_Groups ON qselActiveABCProjects.GroupId = midasuser.dbo_Groups.Id LEFT OUTER JOIN
midasuser.qselSubProjects() qselSubProjects ON qselActiveABCProjects.Id = qselSubProjects.ParentId
WHERE (midasuser.dbo_Groups.Name = @Combogroup)

And I’m still getting a prompt to enter data can any body help a newbie to this tool