Reports - Manual Filter/Changing Criteria

[DavidQMP]

Hi,



So I've got a report that lists all sales within a month, and their value. What i want to do is create a manual entry field on the report, so that users can input the transaction number to only return the information specific to that transaction. (I do not want them editing the queries etc).

I would prefer (if its possible) that inputting the transaction number would update the criteria within the query, but if a report filter is the only way to go then i'll have to make do.

Appreciate any help,

Thanks

[ranman256]

On a form,put a cboBox, user selects the number.
the query would be:
select * from table where [dept]=forms!myForm!cboBox

a button would open the report,
docmd.openreport "myRpt", acPreview

[DavidQMP]

On a form,put a cboBox, user selects the number.
the query would be:
select * from table where [dept]=forms!myForm!cboBox

a button would open the report,
docmd.openreport "myRpt", acPreview

I've created a button to open the report, but cannot seem to get the first part right. Is it possible via macro or expression builder? The number is in a query rather than a table if that makes any difference..