Lucia has attended:
Access Intermediate course
Refresh
Hi!
Is there a way of creating a "Refresh All" button or command in a form, so that it will bring information just entered in another form to the current form I'm working on?
I created a "refresh" button using the button in the design tools but it didn't work. I tried changing the command to "RefreshData", RefreshPage" but nothing worked.. However, if I click Refresh All in the ribbon, it works! Any ideas of what the command should be or what can be going wrong?
Many thanks!
Lucia Possas
RE: Refresh
Hi Lucia, thanks for your query. You need to attach:
Me.Refresh
...to your refresh button to update the current form with information entered into another. Refresh All cycles through all open forms and controls and updates them and to do this in code you need to count the number of open objects, loop through them and refresh them one by one which might be overkill for what you're trying to achieve. Make sure the information entered into the previous form has been saved to the database before you refresh your new form.
Hope this helps,
Anthony
