form does not update

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

Guest

I have a form based on a single table containing data for various suppliers.
The form is intended for the purposes of displaying the data and not for
editing them as the users of the database will not need to update the
information in the source table. The problem is that when I update the source
data by typing directly into the table, the changes are not reflected in the
form. I have added a Form_Load Me.Requery Sub which seems to have done the
trick in terms of removing the records that I have deleted from the source
table, but the new records that I added do not appear in the form view. Any
ideas what might be causing this and how i might solve it?

Jake
 
1) Why are you working directly with the table? That is pretty much a
no-no.

2) What is the record source for your form? Is it based on a query?
 
yes the record source is based on a query, but the query only refers to the
one table.

surely a requeried form should return all the data from the table regardless
of how they were entered? Is it likely to make a difference if I create a new
form which updates the table? Sorry if this is an obvious question but I'm
learning as I go here...

thanks

jake
 
When you edit the data (by typing directly into the table) at what point do
you tell Access to write those changes back out to the database. If this is
done in a form, you either need to navigate to a different record or
implement a DoCmd.RunCommand (acCmdSaveRecord) behind a "Save" button (or
something like that).

The form that displays the data will only see what is already written to the
database.

Bob.
 
Back
Top