Update Form from Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Two Tables Using One Form Contents 0
Separate Form 0
VBA - retrieve data on last create named range from previous inserted named range 0
Data entry for a table from a form 2
Validation Rule assistance 0
Access Automatically Send a notification email once a record is added 0
Data entry to table from a form 1
Creating a Form from a Table 2003 3

Back
Top