I have a report based on a query. I would like to be able to open that report from an OnClick event but limit the query to a particular value for one of the fields. The value must be supplied from within the vba code. So the logic in the code would be something like this:
it's probably some simple solution, but since I'm learning Access by reading forums and googling - there are many gaps in my knowledge.
open report where myquery.somefiled=myCalculatedValue()