Can anyone suggest a method to update my table from a data entry form? Changes to my data are not saved to the table until I close the database. I don't know if this makes a difference, but I am also using the data entry form to update existing records.

So far I have tried the following:

1)opening the table and saving it with a macro
2)saving the form using the onUpdate, onChange events.
3)A combination of both, opening the table saving it, saving the form.

Any help would be greatly appreciated. I need to update the data because I have a synchronized form that refers to it.

If you are using a bound form, Access will save the updated record when you close the form or move to a different record. If you need to save the record using the following line of code:
DoCmd.RunCommand acCmdSaveRecord

Put it in whatever event you want to save the record from.