I have made a Menu based Access 2000 application – but have one problem.
I want to – from a single record view form – to start preview of a defined report – with just the one record that is visible in the form.
Both the form and the report is based on the same query, and the result og the query displays more than one record – thus enabling me to page forward/backward from record to record in the form.
So I guess the question is really – from a multi-record query used in a form – how do you select the currently displayed record and start a report limiting it to just the one selected record.
Anyone ?