Good Evening,

I would like some advise on how to create a report which allows me to search
only for a specific set of results. For example i would like to run a report
which allowed me to type in the company name prior to the report opening and
would then only produce a report based on my search criteria. do i need to
design a query or form before hand? any help appreciated.

many thanks

matthew

On Sat, 4 Nov 2006 20:00:36 -0000, matthew perry wrote:

> Good Evening,
>
> I would like some advise on how to create a report which allows me to search
> only for a specific set of results. For example i would like to run a report
> which allowed me to type in the company name prior to the report opening and
> would then only produce a report based on my search criteria. do i need to
> design a query or form before hand? any help appreciated.
>
> many thanks
>
> matthew

Create an unbound form.
Add a combo box.
Set the Row Source of the combo box to include the
CompanyID field and the Company Name.
Name the Combo Box 'FindCompany'.
Set it's Bound column to 1.
Set it's Column Count property to 2.
Set the Column Width property to 0";1"

Add a Command Button to the form.
Code the button's click event:

Me.Visible = False

Name this form 'ParamForm'.

In the Report's Record Source [CompanyID] field criteria line write:
forms!ParamForm!FindCompany

Next, code the report's Open event:
DoCmd.OpenForm "ParamForm", , , , , acDialog

Code the report's Close event:
DoCmd.Close acForm, "ParamForm"

When ready to run the report, open the report.
The form will open and wait for the selection of the Company and the
entry of the starting and ending dates wanted.
Click the command button and then report will run.
When the report closes, it will close the form.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

thanks for your advise.. i understand it all however i must be being really
thick co i cant work out how to create an unbound form. can you please help.

matthew

"fredg" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Sat, 4 Nov 2006 20:00:36 -0000, matthew perry wrote:
>
>> Good Evening,
>>
>> I would like some advise on how to create a report which allows me to
>> search
>> only for a specific set of results. For example i would like to run a
>> report
>> which allowed me to type in the company name prior to the report opening
>> and
>> would then only produce a report based on my search criteria. do i need
>> to
>> design a query or form before hand? any help appreciated.
>>
>> many thanks
>>
>> matthew
>
> Create an unbound form.
> Add a combo box.
> Set the Row Source of the combo box to include the
> CompanyID field and the Company Name.
> Name the Combo Box 'FindCompany'.
> Set it's Bound column to 1.
> Set it's Column Count property to 2.
> Set the Column Width property to 0";1"
>
> Add a Command Button to the form.
> Code the button's click event:
>
> Me.Visible = False
>
> Name this form 'ParamForm'.
>
> In the Report's Record Source [CompanyID] field criteria line write:
> forms!ParamForm!FindCompany
>
> Next, code the report's Open event:
> DoCmd.OpenForm "ParamForm", , , , , acDialog
>
> Code the report's Close event:
> DoCmd.Close acForm, "ParamForm"
>
> When ready to run the report, open the report.
> The form will open and wait for the selection of the Company and the
> entry of the starting and ending dates wanted.
> Click the command button and then report will run.
> When the report closes, it will close the form.
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail

On Sat, 4 Nov 2006 21:22:52 -0000, "matthew perry"
<(E-Mail Removed)> wrote:

>i cant work out how to create an unbound form.

Create a new Form.

When Access asks you what table or query to use, leave it blank and
open the form anyway.


John W. Vinson[MVP]