98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Refresh
Refresh
Resolved · Low Priority · Version 2007
Wed 11 Aug 2010, 12:28Delegate Lucia said...
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
Thu 12 Aug 2010, 01:48Trainer Anthony said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:How To Display An '&' In A Label In A FormTo have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as: |
