Forms that use the database

[Eric Plante]

I have access 97 and I made a couple tables and forms before noticing that
everytime I open a form, all the data from the database is loaded as well
starting at the first item but what I need are forms that fetch, add, delete
or update data from the database without caring about every other data. Is
there a way to do that?

 

[Mike Painter]

I have access 97 and I made a couple tables and forms before noticing that
everytime I open a form, all the data from the database is loaded as well
starting at the first item but what I need are forms that fetch, add, delete
or update data from the database without caring about every other data. Is
there a way to do that?

You can scroll through or add records by using the controls at the bottom
of the form.
You may want to add a few comboboxes or use filter by form or filter by
value to find the records you wish to delete or update.
You do not need separate forms to do this.

It is possible to open blank form and use additional coding to find just the
records you want or to base the form on a query which contains a limited set
of records.

In the vast majority of cases I've worked with the default that you see is
the best of all possible worlds.