Refreshing a Form to display new records that were adding using a button and VBA code

[bell]

Hi all,

I have a button on a form that allows the user to create multiple records with the same information (but incremented keys)

After the button is clicked, I tried to view the records I have just added on the form, but the form still shows the last record that was physically entered (not the last record that was added from the button click.

I noticed if I close the form and reopen it, I am able to see the records included the ones recently added from the button click



Is there a way to refresh the form without needing to close it?

I tried adding
Me.Refresh
to the end of the button click function

I have also tried adding
Me.Refresh
Me.Repaint

And then I added this
MsgBox "Finished Adding Records"
Me.Refresh
Me.Repaint



because I thought that maybe adding a message box would make the form lose focus to allow for the refresh to work

...but still none of these work :/
Does anyone have any ideas?

[Rawb]

Use Me.Requery instead.

Me.Repaint and Me.Refresh only redraw the Form without checking to see if the backend data has been changed.

[bell]

Thank you! Me.Requery worked great!