refreshing a form instead of closing to update record.

[RLehrbass]

My form is not updating the table record until I actually close the form.
Is there VBA code to refresh the record and leave the form open so I can perform other actions designated on the form?



I tried the following but it did not store the record in the table: I still had to close the form or go to another record then return to continue???

Private Sub cmdUpdateRecord_Click()
On Error GoTo Err_cmdUpdateRecord_Click

DoCmd.RunCommand acCmdRefresh

Exit_cmdUpdateRecord_Click:
Exit Sub

Err_cmdUpdateRecord_Click:
MsgBox Err.Description
Resume Exit_cmdUpdateRecord_Click

End Sub

[IrogSinta]

If you want to get the latest changes to any of the values in the current records you are showing, you would add the following in your code:
Me.Refresh

If records to be displayed will be different because some have been deleted or new ones have been added or a different set now meet the criteria in your recordsource, you would use:
Me.Requery

Ron

[Paul H]

try running this.

        DoCmd.RunCommand acCmdSaveRecord