What to use... form or report??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that shows line by line some invoces.
Since there are 1000's of invoices, I need to group them in 2 categories. To
do this using report is perfect. But my problem is one extra feature I need
in the report.
Near each line, I would like to insert a command button(or what ever you
would suggest), so that when the user clicks that button, access opens a
scanned file(where the path and file name is stored in a text box).
In reports, I can insert a command button, but it does not let me to write a
code.
If I use forms, I don't know how to group the lines.

What would you do...

thanks
 
Jack,

Sounds like it will be used "on screen" rather than as a
printed report. Use a form. You will need to do your
grouping and sorting in a query.
This can be achieved using total queries (query design
View|Totals) joined to your base query and sorted. You can
group using this type of query.

HTH,

Terry
 
Back
Top