Report of selected field

  • Thread starter Thread starter Greg McLandsborough
  • Start date Start date
G

Greg McLandsborough

I have a list of items, that have a relation to a project id, I want to
create a report that selects all the items for a certian project, which i
can select from a combobox. Can anyone give me some indication of how to go
about this.

Thanks for any help

Greg
 
I have a list of items, that have a relation to a project id, I want to
create a report that selects all the items for a certian project, which i
can select from a combobox. Can anyone give me some indication of how to go
about this.
Click to expand...

Create a little unbound form with the combo box on it. Create a Query
using

=[Forms]![NameOfYourForm]![NameOfTheCombo]

as a criterion to select the project ID.

Base your Report on this query, and put a command button on the form
to launch the report.

John W. Vinson[MVP]
 
Thank John,
That works, sort of.

the report prompts me for the Project Id, But I were hoping to have a
combobox with the Project names so that I could select the Project. If
you've got any more advice I'd appreciate it.

Thanks again

Greg
John Vinson said:
I have a list of items, that have a relation to a project id, I want to
create a report that selects all the items for a certian project, which i
can select from a combobox. Can anyone give me some indication of how to go
about this.
Click to expand...

Create a little unbound form with the combo box on it. Create a Query
using

=[Forms]![NameOfYourForm]![NameOfTheCombo]

as a criterion to select the project ID.

Base your Report on this query, and put a command button on the form
to launch the report.

John W. Vinson[MVP]
Click to expand...
 
Thank John,
That works, sort of.

the report prompts me for the Project Id, But I were hoping to have a
combobox with the Project names so that I could select the Project. If
you've got any more advice I'd appreciate it.
Click to expand...

Set the ColumnWidths property of the combo box so that the ProjectID
(the bound column) is of zero width, and the project name is the first
visible field. If the Report is prompting [Project ID] then you need
to check its query to be sure that you have the correct Forms
reference rather than [Project ID].

John W. Vinson[MVP]
 
Back
Top