Creating work queue list

What is the best method to create a main page that lists all of our open
files? This should work as a menu in that the info for each file cannot be
changed here - it would need to be selected and then opened in a form for
editing. My instinct is that a report would work best but I don't see that I
can format a report to be just a visual report/list on which I can create
command buttons and such for navigating.

Thanks for any help.

Pamela

Simply create a query that returns a list of all your open files. Then
create a continuous form based on the query. The form will display the list
of your open files. Open properties and turn off Allow Addidions and Allow
Deletions. Finally place code in the click event of one or more of your
fields in this form that opne the appropriate form for editing your open
file.

Steve



"Pamela" wrote in message
...
What is the best method to create a main page that lists all of our open
files? This should work as a menu in that the info for each file cannot
be
changed here - it would need to be selected and then opened in a form for
editing. My instinct is that a report would work best but I don't see
that I
can format a report to be just a visual report/list on which I can create
command buttons and such for navigating.

Thanks for any help.

Pamela

Create a listbox of open files (whatever that means) on a form. You can then
add command buttons to open other forms or whatever based on the value of the
listbox.

--
Duane Hookom
Microsoft Access MVP


"Pamela" wrote:

What is the best method to create a main page that lists all of our open
files? This should work as a menu in that the info for each file cannot be
changed here - it would need to be selected and then opened in a form for
editing. My instinct is that a report would work best but I don't see that I
can format a report to be just a visual report/list on which I can create
command buttons and such for navigating.

Thanks for any help.

Pamela