Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Forms to pass parameters to Ms Access Project inline fuction qry

Status
Not open for further replies.

macsman

IS-IT--Management
Aug 27, 2001
5
0
0
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top