• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 258
  • Last Modified:

Linked Oracle table refresh question

In my Access form, it's linked to an Oracle table, seems only when I close the access form, the current records are saved to Oracle table (they are linked), how to force save or synchronize the linked table? Thanks.
1 Solution
On your save button add:
    DoCmd.RunCommand acCmdSaveRecord
    Me.Dirty = False

On your exit button add:
If Me.Dirty = False Then
    DoCmd.Close acForm, "frmEdit", acSaveNo
ElseIf MsgBox("Save Changes?", vbYesNo, "Save") = vbNo Then
    If Me.Dirty = True Then
    End If
    DoCmd.Close acForm, "frmEdit", acSaveNo
        DoCmd.Close acForm, "frmEdit", acSaveNo
End If

On your forms properties, set Close button to No.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now