Having fun with adp's. Using Ms Access 2002.
I have a login form called frmLogin which has two combo boxes cboStatus and cboResource. I am trying to select parameters from the combo boxes then open a form (frmTaskList -which uses an inline function query) with the Record Source qfctTasks.
My query is:
Select * from dbo.tblTaskAdmin where (Status=@Enter_Status) AND (Resource=@Enter_Resource]))
I tried setting the Input Parameters of the form but I am still getting prompted for the status and resource. Ex.
@Enter_Status varchar =[frmLogin]![cboStatus],@Enter_Resource varchar = [frmLogin]![cboResource]
I know there is something I'm forgetting but I don't see it in the help file. Also I would like the option to return all if nothing is selected.
TIA for any help,
macsman
I have a login form called frmLogin which has two combo boxes cboStatus and cboResource. I am trying to select parameters from the combo boxes then open a form (frmTaskList -which uses an inline function query) with the Record Source qfctTasks.
My query is:
Select * from dbo.tblTaskAdmin where (Status=@Enter_Status) AND (Resource=@Enter_Resource]))
I tried setting the Input Parameters of the form but I am still getting prompted for the status and resource. Ex.
@Enter_Status varchar =[frmLogin]![cboStatus],@Enter_Resource varchar = [frmLogin]![cboResource]
I know there is something I'm forgetting but I don't see it in the help file. Also I would like the option to return all if nothing is selected.
TIA for any help,
macsman