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