changing a filtered report to a filtered form

[Sarah]

I use a form and associated query to select customer, month and year, and
then produce a report showing all invoices for that customer in the month and
year selected. Could I change it so that it shows the same information as
the report but on a form instead? I want to be able to amend some of the
results, and obviously can't do that if it is just in report format.

Thanks

Sarah

 

[Arvin Meyer [MVP]]

Certainly. Just create a form which reads from the same query as the report.
It's almost as easy to create from scratch, but you can copy the report
controls and paste them into a form. I, personally, would rather drag the
controls from the field list in the form's design view.

 

[Sarah]

But if I base the form on the query I can't change any of the entries can I?

 

[Arvin Meyer [MVP]]

Sure you can, as long as the query is editable (most are). Queries can be
used the same as tables, with the additional benefit that you can create
calculated columns. Look at the [Order Details Extended] query in the
Northwind sample database that came with Access. Notice the [Extended Price]
column. You can't edit it, but it displays the total on the Order Details
subform. You can edit the rest of the fields.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com