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 VBA Training and help » access course london - VBA coding to refresh a subform
access course london - VBA coding to refresh a subform
Resolved · Low Priority · Version Standard
Thu 16 Aug 2007, 14:44Delegate Julie said...
Julie has attended:
Access Advanced course
Access VBA course
VBA coding to refresh a subform
I have a form with an attached subform (which is in datasheet view). I need the subform to refresh automatically when the focus shifts back to the main form. The only way i have found to do this so far is to close and reopen the whole form which is a bit jerky for the user.
Is there any command that can do this?
Mon 15 Oct 2007, 17:16Trainer Richard said...
RE: VBA coding to refresh a subform
Try adding the following code to an event procedure on the GOTFOCUS Event of the entire form.
Private Sub FormName_GotFocus()
Me.Refresh
End Sub
Training information:
|
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:Duplicating an EntryTo duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field. |
