Macro - not pulling current record

[jlo33jenn]

I currently have this macro set up on a form:

Action: OpenReport
Arguments: Invoice, Print Preview, , =[Forms]![Project Details]![ID], Normal

What it is currently doing is pulling the last record on the form into a report. However, I could be on the 3rd or 4th record of 10 and it still does this. What I am hoping this macro would do is open up whatever current record I am on into the report, or provide me with a pop-up box to enter in the ID/record number I am wanting to have printed.

Thanks for your help!

[ranman256]

Open the form ,check the ID on the form
now open the query (that the report uses)
Is it pulling the current record?

I dont see how it cant. If the report uses this query, that uses that ID, then it can ONLY pull that record.

[jlo33jenn]

Thanks. I think I can see why it isn't working now. Looks like something is wrong with my query. I'll work on that and see if that fixes things.

Thanks for giving me a fresh look on it! I think I was staring at it way too long and that's why I kept missing what was not working.