Showing certain records in a form

[Jeffrey Marks]

The users of a database I am converting to MS ACC07 want to use the
the arrows at the bottom of the form (e.g. 1 of 1949 with the arrows)
to navigate. I have given them other ways to navigate between records
in the table, but they still want to use this.

The table is called Outings and has information on events for 4
different programs. Each program manager only wants to see the Outing
records in the table for their Program. Is there a way to do this
easily?

Thanks

Jeff

 

[Mike Painter]

The users of a database I am converting to MS ACC07 want to use the
the arrows at the bottom of the form (e.g. 1 of 1949 with the arrows)
to navigate. I have given them other ways to navigate between records
in the table, but they still want to use this.

The table is called Outings and has information on events for 4
different programs. Each program manager only wants to see the Outing
records in the table for their Program. Is there a way to do this
easily?

One way is to build the form on a query that selects for the manager and use
a combo box to allow them to filter on their ID.

However sinccnce they want to use the default navigation tools why not show
them how to do their own filtering by right clicking on their ID or name
field.