refreshing recordset

  • Thread starter Thread starter Allen Browne
  • Start date Start date
A

Allen Browne

Requery the form, e.g.:
Forms!Form1.Requery

The form will be reloaded, so it will return to the first record.

Make sure the form is not dirty before you write to the table. Otherwise you
have a write conflict.
 
Hi all,

I have a form open & i run code to append data to the underlying table of
the form.

The open form doesn't show that record unless i close the form and re-open
it. How can I refresh the data so it will be available without closing the
form and re-opening it?

TIA
Ted
 
I had a similar issue using an Add Client button. The problem was solved by
attaching this code to the On_Exit event for the button...

Private Sub AddClient_Exit(Cancel As Integer)
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
End Sub

I'm not sure that I fully understand the working of the code but have not
had any problems since applying it.
 
Back
Top