Requery split form data button

[Evans2]

Hi all,

First let me say that the help/knowledge I've received on this forum has been a life saver.



I've got a split form used by multiple users throughout the day. I've got a refresh button that I thought would refresh all data entered and bring the split form up to date by showing new entries. What it does is actually just refresh currently shown data. New entries are only shown when the database is closed and reopened.

Through searching, I've discovered that I need to requery the data to show new entries not just refresh. My question is, how can I link this to a requery to a button so that the user can simply click to show all new entries without closing and reopening the database.

Screen shots below show the database skipping a number (not refreshing new entries after refreshing) and displaying new entries after reopening.

[Evans2]

I jumped the gun and figured this one out myself. Thanks!

[Missinglinq]

...I've got a refresh button that I thought would refresh all data entered and bring the split form up to date by showing new entries...

Refresh is probably one of the most misunderstood methods in Access, even by experienced developers! As you've found out, it merely shows changes made to those Records that were a part of the RecordSet when the Form first opened. It does not show New Records, nor exclude Records that have deleted, since the Form opened.

It's always good when you can solve a problem yourself, but forum etiquette requires that you post the solution. In this way, your solution may help others who find this thread, seeking an answer to the same question.

Good luck with your project!

Linq ;0)>

[Evans2]

Hi Linq,

I used this requery code in the on-lick event in the form properties: Me.Requery

I also used the following last record code so that when the user clicks on the refresh button, they will also be taken to the last entry in the database: DoCmd.GoToRecord acDataForm, "Form Name", acLast

Screenshot below. Thanks again for the help. Much appreciated!