Reports

[Guest]

I am trying to product a report determined by what I select in a dropdown
menu. i.e. On a form I have a dropdown menu where I can select a Surname.
what I would like to happen is when I select this Surname it produces all the
Invoices relating to this person only so I can scroll through them.

 

[kingston via AccessMonster.com]

Depending on how complex the data structure and report is, you can do this
directly in the report or create a query first. To do this in the report,
use the combobox's (dropdown menu?) AfterUpdate event to open the report with
a filter: "[Surname]='" & Me.combobox & "'" For greater flexibility, use a
query based on the selections of the form to feed the report: output field
[Surname] with criteria [Forms]![MainFormName]![ComboBox].

 

[Guest]

Many Thanks
I will give it a go.

Steve

Depending on how complex the data structure and report is, you can do this
directly in the report or create a query first. To do this in the report,
use the combobox's (dropdown menu?) AfterUpdate event to open the report with
a filter: "[Surname]='" & Me.combobox & "'" For greater flexibility, use a
query based on the selections of the form to feed the report: output field
[Surname] with criteria [Forms]![MainFormName]![ComboBox].

I am trying to product a report determined by what I select in a dropdown
menu. i.e. On a form I have a dropdown menu where I can select a Surname.
what I would like to happen is when I select this Surname it produces all the
Invoices relating to this person only so I can scroll through them.