Form Based on Report

[alecgreen]

Hi

Is it possible to replicate a report on a data entry from? I have
tried but could sort or group records

Many Thanks

Alec

 

[John W. Vinson]

Hi

Is it possible to replicate a report on a data entry from? I have
tried but could sort or group records

Many Thanks

Alec

No.

Data is stored in Tables, and onlly in Tables.

Use the Form to update one or more Tables, and base the Form on a query of
those tables.

You can display data from a form on a report by setting the control source of
a textbox on the report to

=Forms!NameOfYourForm!NameOfSomeControl

but this would just be a single, static value and could not be used in sorting
or grouping.

 

[Saji Ijiyemi]

Hi John,
How will I be able to create a report interface that the users could pick and choose different criteria and generate a report on the fly.

I have main tables which serves my main form and junction tables which serves my subform.

Thanks.



John W. Vinson wrote:

Re: Form Based on Report
07-Sep-09

No.

Data is stored in Tables, and onlly in Tables.

Use the Form to update one or more Tables, and base the Form on a query of
those tables.

You can display data from a form on a report by setting the control source of
a textbox on the report to

=Forms!NameOfYourForm!NameOfSomeControl

but this would just be a single, static value and could not be used in sorting
or grouping.
--

John W. Vinson [MVP]

EggHeadCafe - Software Developer Portal of Choice
SQLiteHelper (a.k.a. SQLHelper) for SQLite.NET
http://www.eggheadcafe.com/tutorial...-b9f0-eca7b0f51c9a/sqlitehelper-aka-sqlh.aspx

 

[John W. Vinson]

How will I be able to create a report interface that the users could pick and choose different criteria and generate a report on the fly.

By basing the Report on a Parameter Query using criteria such as

=[Forms]![MyFormName]![SomeControlName]

as criteria.

For a more specific answer please feel free to post a more specific question.

 

[Jackie L]

Create a form (frmReportMenu) with unbound criterial fields. For instance:
BeginningDate and EndingDate. Then, when you create the queries to run your
reports, use the unbound fields as your criteria. So, your criteria would
be like Between Forms!frmReportMenu!BeginningDate and
Forms!frmReportMenu!EndingDate. Put a button on your frmReportMenu to open
the report.

Sorry, this is a very basic start. I hope it helps.