How do I open my form with a query?

[livingwater]

I have a database of customer feedback that contains part numbers, report numbers aircraft numbers and some other categories. I assign engineers to address the particular issues for the incoming reports (opportunities). I want my guys to be able to pick or input their name, and have the form come up with only their assigned tasks attached.

I've used a db like thi in the past but don't know how it was made.

Thanks,
Paul

 

[shannonp]

Cart before the horse??

Your title states you want to open a form with a query. As far as I know...it can't be done.

Perhaps what you wanted to do is create a form based on a query that is filtered by 'Engineer ID'.

Query would look something like this:

SELECT [tbl_engineer job].[Engineer ID], [tbl_engineer job].[Job ID]
FROM [tbl_engineer job]
WHERE ((([tbl_engineer job].[Engineer ID])=[Enter Your Engineer ID #]));

 

[yduckfr]

Make 1 form with a Combo box to select a name and a comand buton to close this form and open the other form

Make a 2nd form based on a the table with the tasks

In the click event of the command button on the first form enter the following code:

DoCmd.OpenForm "[i]2nd Form Name[/i]",,,"Name = '" & Me.[i]Combo Box[/i] & "'"

DoCmd.Close acForm, Me.Name