A simple question

E

Edward

Hi everybody,
I have created three tables and three forms to populate those tables but
when I use those forms to enter data tables dont update immediately ,and I
nned to close the data base and open it again to update the recently entered
records? I'm new in Access so please give a hint.
 
J

John B. Smotherman

Edward,

MS Access doesn't commit a transaction immediately while you're still
viewing the record in the form. For example, if you're looking at record
number one in the form and you make a change to the record, the change is not
committed to the table until you move to another record, or close the form.
This allows you to "change your mind" and hit the escape key to cancel your
change BEFORE you move to another record.

Try this: make a change to a record, move to the next record using the
record navigation buttons at the bottom of the form, then move back to the
record you just changed. You'll see the changes have been committed.

HTH.
 
E

Edward

Thanks, acctually I was more concerned about when I add a new record using a
form, which I think follows the same concept you explained, when I add a new
reocrd using a form and move to a new one , when I open the table new record
is not saved only when I close the form then I can see the new record added .
Is this the way Access works?
 
J

John B. Smotherman

You should be able to see the new record in the table without closing the
form. Advancing to the next record will commit the update to the table.

Do you have the table open at the same time you have the form open? This
will cause the behavior you mention, because what you see in the datasheet
view of the table is a "snapshot" of the table as it exists when you opened
it. If you opened the table before you added the new record, you won't see it
until you close the table and reopen it.

-JBS-
 
Top