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.