Update Form from Table

K

Kim P.

I am not new to Access but new to forms. I am using Access 2000 and have
created a table and a form based on that table. How do I get the form to
automatically update when I enter new data into the table?
 
K

Klatuu

Kim,

You question seems a bit backwards. Why do you want to update the table
and have it show in the form?
When you open a form, it establishes its recordset. If new records are
added to the table manually while the form is open, the form doesn't know
about the new records. To make the form aware of the records, you have to
requery the form, but this does not make sense in a normal application.

If I am not understanding correctly, please post back.
 
Top