Forms that only take data

  • Thread starter Thread starter Eric Plante
  • Start date Start date
E

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?
 
To add:
Go to a new record, or have your form open in data entry mode
To Delete:
Find the record you want, and delete it.
To Update:
Find the record you want and make the desired changes.

Finding the records to update and delete can be accomplished using the Find
function (see the binoculars on the toolbar), or by basing the form on a
Query that takes a parameter. It will then open to the correct record.
There are more glamorous ways, but those are the simplest.

In short, your database is currently doing exactly what you have told it to
do thus far. :-)
 
I should have taken a better look at the tool bar hehe, thanks. There is one
remaining problem though.

The delete effectively deleted the data from the main form's table but not
from the child forms's table. Is there a way to make it automatic instead of
having to delete every rows in the child's form first?

thanks
 
Yes. Create a relationship between the two tables, click the checkbox to
enforce referential integrity and check cascade deletes
 
Back
Top