How to: Report that pulls only one Record

[FreddieLeaf]

I've done this before but cant get it to work in this new project. I want to print a receipt for a particular item in a table. I recall that if done right, the Report will ask you to enter the ItemID when the Report is opened. It's not doing that/

Here is what I did.
1) Create a query that pulls all the info I want on the receipt.
2) On the ItemID field, I put the criteria as 'ItemID' from the table.
3) Create a report that opens uses this query as the data.
4) The Report open up ALL the records instead of prompting for just one...

help...

 

[KeithG]

Use [Enter Item ID] instead of 'ItemID' or you can use [ItemID] but make sure you put brackets around the parameter []

 

[statsman]

It sounds like you forgot to put a parameter prompt in your query.